To generate a SQL Server data dictionary by using an SQL statement ^

server|sqlserver| Data | Statement SELECT table name =case when a.colorder=1 then D.name else ' "End,
--Field ordinal =a.colorder,
Field name =a.name,
--Identify =case when ColumnProperty (A.id,a.name, ' isidentity ') =1 then ' √ ' Else ' "end,
/* Primary key =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 colid=a.colid))
Then ' √ ' Else ' end,
*/
Type =b.name,
--Takes up bytes of =a.length,
Length =columnproperty (a.id,a.name, ' PRECISION '),
Decimal Places =isnull (ColumnProperty (a.id,a.name, ' Scale '), 0),
Allow empty =case when a.isnullable=1 then ' √ ' Else ' end,
Default value =isnull (E.text, ""),
Field Description =isnull (G.[value], "")
From syscolumns a LEFT join systypes 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