SELECT (CASE WHEN A.COLORDER = 1 THEN D.NAME ELSE '' END) N 'Name', A.COLORDER N 'Field Series', A.Name N' Field Name, (Case When ColumnProperty (A.ID , a.name, 'isidentity') = 1 Ten '√'lse' 'end) N' Identification '(Case When (Select Count (*) from sysobjects where (select name from sysindexes where (id = A) .id) AND (INDID INDID) AND (ID = A.ID) AND (Colid in (Select Colid from syscolumns where (id = a.id) and (name = a.name) ) --- End Select Colid) ---- End: Colid IN) ----------- end: select Indid -------------- End: IndID IN) ----------- End select name) ------- end name in and (xtype = 'pk') ------- end where)> 0 - --------- End when the '√' else '' end) n 'primary key', B.Name N ', A.Length N' occupies bytes'
, ColumnProperty (A.ID, A.NAME, 'Precision') AS N 'Length', ISNULL (ColumnProperty (A.ID, A.NAME, 'Scale'), 0) AS N 'Digital number', (Case) When a.isnullable = 1 Then '√'ELSE' 'end) N' Allow empty ', isnull (e.text,' ') n' default ', isnull (g. [value],' ') AS N' Field Description '- Into ## TX
From syscolumns a left a.xUsertype = b.xUsertypeinner Join Sysobjects D on a.id = D.ID and D.XTYPE = 'u' and d.name <> DTPROPERTIES'LEFT JOIN SYSCOMMENTS E ON A. CDEFAULT = E.IDLEFT JOIN SYSPROPERTIES G on A.ID = g.id and a.colid = g.smallid ORDER BY Object_name (A.ID), A.COLORDER
