正文
sql server 查看列备注、类型、字段大小
提示：扫一扫查出行【扫一扫了解最新限行尾号】
复制提示
select
列名 = a.name
,类型 = c.name
,长度 = columnproperty(a.id,a.name,'precision')
,备注 = g.value
from syscolumns a
left join sysobjects b on a.id=b.id
left join systypes c on a.xusertype = c.xusertype
left join sysproperties g on a.id =g.id and a.colid =g.smallid
where b.name = 'TBL_ORD_MAIN'
