Ahmet Hoso - Blogs

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

SQL Server 2005'de tablo hazırlarken kolonlara yazılmış description'ları kodla alabilmek için aşağıdaki sorgu kullanılır SELECT OBJECT_NAME(c.object_id) as [Tablo Adı], c.name as [Kolon Adı], ex.value as [Açıklama] FROM sys.columns c LEFT OUTER JOIN sys.extended_properties ex ON ex.major_id = c.object_id AND ex.minor_id = c.column_id AND ex.name = 'MS_Description' WHERE OBJECTPROPERTY(c.object_id, 'IsMsShipped')=0 -- AND OBJECT_NAME(c.object_id) = 'Aciklaması_Istenen_Tablo_Adı' ORDER BY OBJECT_NAME(c.object_id), c.column_id