Select Name = Case When a.colorder = 1 Then D.Name Else '' end,
Field serial number = a.colorder,
Field name = a.name,
Logo = Case When ColumnProperty (A.ID, A.NAME, 'ISIDENTITY') = 1 TEN '√'lse' 'end,
Primary key = Case When EXISTS (SELECT 1 from sysoads 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))))
Then '√' else '' end,
Type = B.Name,
Use by one number = a.length,
Length = ColumnProperty (A.ID, A.Name, 'Precision'),
Digital digits = 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 systemypes b on a.xtype = b.xUsertype inner join sysobjects d on A.ID = D.ID
And D.XTYPE = '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
