Select Name = Case When a.colorder = 1 Then D.Name Else '' end, - field number = a.colorder, field name = a.name, - Identification = Case When ColumnProperty (A.ID, A. name, 'IsIdentity') = 1 then '√'else' 'end, / * primary = case when exists (SELECT 1 FROM sysobjects where xtype =' PK 'and name in (SELECT name FROM sysindexes WHERE indid in (SELECT indid FROM Sysindexkeys where id = a.id and color = a.colid))))))))))) "√ 'else' 'end, * / type = B.Name, - Total bytes = A.Length, Length = ColumnProperty (a. ID, A.NAME, 'Precision', decimal number = isnull (columnproperty (A.ID, A.NAME, 'Scale'), 0), Allow empty = case when a.isnullable = 1 Then '√'lse '' end, default = isnull (e.text, ''), field description = isnull (g. [value], ') from syscolumns a left join systempes b on a.xtype = B.XUSERTYPE INNER JOIN SYSOBJECTS D ON A.ID = D.ID and D. xipe = 'u' and d.name <> 'dtproperties' Left Join SysComments E on a.cdefault = E.ID Left Join Sysproperties g on A.ID = g.id and A.Colid = g.smallid Order by A.ID, A.COLORDER
