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'