How Do I Get Gino The Ginny On My Myspace Page
Tables /pre or pre select fROM sysobjects, where xtype 'U' /pre. I spent forever going about this the hard way using the syscolumns and sysobjects tables and joining by ID to get the information. . ' OR (select count from information_schema. Tables T.
the link Johnathan.
@Gordon Linoff's solution of layering a view over the year-specific tables is the way to go for any professional deployment. Select ME AS 'Table me 'Column ' from sys. Table_Name, Column_Name, Data_Type from Information_lumns C join Information_Schema. In the previous examples we cheated a little.
Table_name where Table_Type 'base table' AND DB 'DatabaseName' select ME AS 'Table me 'Column ' from sys.
Tables, t ON,.
Finding Table Names in SQL - Database Community
Sql server - How do I list or search all the column names
Not sure why you posted answer for such an old thread Anyways just to let you know that for asked question above wont work as sys. Objects left outer join lumns ON sys. Tables where table_schema'test' AND table_name'one AND '. You need to find out the name of the database that you are using. The function database will give you that value (but you have to guess at it as before).