Wednesday 30 November 2011

Get List of all columns of table

so_columns tablename
for example :- sp_columns employee

or

SELECT   SysObjects.[Name] as TableName,  
    SysColumns.[Name] as ColumnName,  
    SysTypes.[Name] As DataType,  
    SysColumns.[Length] As Length  
FROM  
    SysObjects INNER JOIN SysColumns  
ON SysObjects.[Id] = SysColumns.[Id]  
    INNER JOIN SysTypes 
ON SysTypes.[xtype] = SysColumns.[xtype] 
WHERE  SysObjects.[type] = 'U' 
-- AND syscolumns.[name] LIKE 'FK%'
ORDER BY  SysObjects.[Name]


No comments:

Post a Comment