sqlserver如何取得表的comment
发布时间：2020-12-12 12:59:21 所属栏目：MsSql教程 来源：网络整理
导读：select ? b.[value]? from ? sys.columns?a? left ? join ? sys.extended_properties?b? on ? a.object_id=b.major_id? and ? a.column_id=b.minor_id? inner ? sysobjects?c? a.column_id=c.id? a.[ name ]= '列名' ? c.[ '表名' ? SELECT ? 表名= case ? w
select?
b.[value]?
from?
sys.columns?a?
left?
join?
sys.extended_properties?b?
on?
a.object_id=b.major_id?
and?
a.column_id=b.minor_id?
inner?
sysobjects?c?
a.column_id=c.id?
a.[
name
]=
'列名'?
c.[
'表名'?
SELECT?
表名=
case?
when?
a.colorder=1?
then?
d.
name?
else?
''?
end
,?
表说明=
then?
isnull
(f.value,
''
)?
COLUMNPROPERTY(?a.id,a.
'IsIdentity'
)=1?
then?
'√'
exists(
SELECT?
1?
FROM?
sysobjects?
where?
xtype=
'PK'?
and?
name?
in?
(?
SELECT?
sysindexes?
WHERE?
indid?
in
(?
indid?
sysindexkeys?
id?=?a.id?
AND?
colid=a.colid?
)))?
'√'?
'PRECISION'
),?
小数位数=
(COLUMNPROPERTY(a.id,255)!important; background:none!important">'Scale'
a.isnullable=1?
(e.text,?
字段说明=
(g.[value],0)!important; background:none!important">)?
syscolumns?a?
systypes?b?
a.xusertype=b.xusertype?
sysobjects?d?
a.id=d.id?
d.xtype=
'U'?
<>
'dtproperties'?
syscomments?e?
a.cdefault=e.id?
sys.extended_properties?g?
a.id=g.major_id?
a.colid=g.minor_id?
sys.extended_properties?f?
d.id=f.major_id?
f.minor_id=0?
--where?d.name='orders'?--如果只查询指定表,加上此条件?
order?
by?
a.id,a.colorder
（编辑：李大同） 【声明】本站内容均来自网络，其相关言论仅代表作者个人观点，不代表本站立场。若无意侵犯到您的权利，请及时与联系站长删除相关内容! |