select a.name as '表明',
ISNULL(d.value, '')
AS 表说明,
a.id as '编号',b.name as '字段' ,c.name as '字段类型', ISNULL(e.value, '') AS 字段说明,
b.length as '字段长度',isnull(b.scale,'') as '小数位数',b.isnullable AS '是否允许为NULL'
from [sysobjects] a,[syscolumns] b, [systypes] c,sys.extended_properties d,
sys.extended_properties AS e
where a.[type] = 'u' and a.id=b.id and b.xtype=c.xtype and a.id = d.major_id
AND d.minor_id = 0 and b.id = e.major_id
AND b.colid = e.minor_id
order by a.id
相关表关系:
sysobjects --表
<pre name="code" class="sql">syscolumns --列
<pre name="code" class="sql">systypes --类型
<pre name="code" class="sql">sys.extended_properties --表说明
<pre name="code" class="sql">sys.extended_properties --字段说明