get a column name multiple table in sql server

Question

I know this trick SELECT * FROM information_schema . columns WHERE table_name = 'Table_Name' i have try this is working wonder full but i want multiple table column like a productmaster and so. Plz tell me any one how can do this.??????

Sibeesh Venu · Answer

SELECT T.NAME AS [TABLE NAME] C.NAME AS [COLUMN NAME] P.NAME AS [DATA TYPE] P.MAX_LENGTH AS[SIZE] CAST(P.PRECISION AS VARCHAR) +'/'+ CAST(P.SCALE AS VARCHAR) AS [PRECISION/SCALE] FROM SYS.OBJECTS AS T JOIN SYS.COLUMNS AS C ON T.OBJECT_ID=C.OBJECT_ID JOIN SYS.TYPES AS P ON C.SYSTEM_TYPE_ID=P.SYSTEM_TYPE_ID WHERE T.TYPE_DESC='USER_TABLE'; Or SELECT TABLE_SCHEMA TABLE_NAME COLUMN_NAME ORDINAL_POSITION COLUMN_DEFAULT DATA_TYPE CHARACTER_MAXIMUM_LENGTH NUMERIC_PRECISION NUMERIC_PRECISION_RADIX NUMERIC_SCALE DATETIME_PRECISION FROM INFORMATION_SCHEMA.COLUMNS

Sibeesh Venu · Answer

select o.namec.name from sys.columns c inner join sys.objects o on c.object_id=o.object_id order by o.namec.column_id http://stackoverflow.com/questions/2729126/how-to-find-column-names-for-all-tables-in-all-databases-in-sql-server