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')
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')
Yorumlar