Herhangi bir tablonun kolonlarının bilgileri
Select Name,IsPrimaryKey=Case when Name= col_name(sysindexkeys.id,sysindexkeys.colid) then 1 else 0 end, Data_type as DataType,CHARACTER_MAXIMUM_LENGTH as Length,colstat as IsIdentity, IsNullable,object_Name(rkeyid) RelationTable,col_name(rkeyid,rkey) RelationColumn from syscolumns inner join INFORMATION_SCHEMA.COLUMNS on INFORMATION_SCHEMA.COLUMNS.COLUMN_NAME=Name left join sysforeignkeys on syscolumns.id =sysforeignkeys.fkeyid and Name = col_name(fkeyid,fkey) left join sysindexkeys on syscolumns.id = sysindexkeys.id where syscolumns.id=Object_ID('Tablo_Adi')