|
方法一：
SELECT
A.name AS table_name,
B.name AS column_name,255); font-family:Arial; font-size:14px; line-height:26px">C.value AS column_description
FROM sys.tables A
INNER JOIN sys.columns B ON B.object_id = A.object_id
LEFT JOIN sys.extended_properties C ON C.major_id = B.object_id AND C.minor_id = B.column_id
WHERE A.name = '表名'
方法二：
SELECT
????????表名=case???when???a.colorder=1???then???d.name???else???''???end,
????????表说明then???isnull(f.value,'')??? ????????字段序号=a.colorder,
????????字段名=a.name,
????????标识when???COLUMNPROPERTY(???a.id,a.name,0); line-height:1.5!important">'IsIdentity')√' ????????主键when???exists(SELECT???FROM???sysobjects???where???xtypePK'???and???name???in???(
????????SELECT???name???FROM???sysindexes???WHERE???indid???in(
????????SELECT???indid???FROM???sysindexkeys???WHERE???id???=???a.id???AND???colid=a.colid
????????)))???'??? ????????类型=b.name,
????????占用字节数=a.length,
????????长度COLUMNPROPERTY(a.id,0); line-height:1.5!important">PRECISION'),
????????小数位数isnull(Scale0),
????????允许空when???a.isnullable ????????默认值isnull(e.text,0); line-height:1.5!important">''),
????????字段说明isnull(g.[value],0); line-height:1.5!important">'')
????????FROM???syscolumns???a
????????left???join???systypes???b???on???a.xusertype=b.xusertype
????????inner???join???sysobjects???d???on???a.id=d.id?????and???d.xtypeUand?????d.name<>dtproperties'
????????join???syscomments???e???on???a.cdefault=e.id
????????join???sys.extended_properties???g???=g.major_id???and???a.colid=g.minor_id
????????join???sys.extended_properties???f???on???d.id=f.major_id???and???f.minor_id0
????????--where???d.name='orders'?????????--如果只查询指定表,加上此条件
????????order???by???a.id,a.colorder
（编辑：李大同）
【声明】本站内容均来自网络，其相关言论仅代表作者个人观点，不代表本站立场。若无意侵犯到您的权利，请及时与联系站长删除相关内容!
|
