34,575
社区成员
发帖
与我相关
我的任务
分享
2000:
select
*
from
syscolumns a
join
sysproperties b on a.ID=b.ID and a.colid=b.smallid
where
a.ID=object_id('T1')
05:
select
*
from
sys.columns a
join
sys.extended_properties b on a.object_id=b.major_id and b.class=1 and b.minor_id=a.Column_id
where
a.object_id=object_id('T1')