MSSQL 如何采用sql語句 擷取建表字段說明、字段備注、字段類型、字段長度

原文: MSSQL 如何采用sql語句 擷取建表字段說明、字段備注、字段類型、字段長度 轉自: http://www.maomao365.com/?p=4983

<span style="color:red;font-weight:bold;">

下文講述-采用sql腳本擷取指定表中所有列對應的說明資訊,

腳本如下所示:

</span>

SELECT
(case when a.colorder=1 then d.name else '' end) [資料表名稱],
a.colorder [列順序],
a.name [列名稱],
b.name as [列類型],
b.length as [列長度],
g.[value] AS [列說明資訊]
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 sys.extended_properties g
on a.id=g.major_id AND a.colid = g.minor_id 
WHERE d.[name] ='IError'--資料表名稱
order by a.id,a.colorder