MSSQL Tips

From HasnoWiki

mssql tips

to select the columns for a table

 select * from information_schema.columns
 select * from information_schema.key_column_usage 
 
 If that doesn't have the level of detail that you require, try
 
 select * from syscolumns
 select * from sysconstraints