Select a.name as 列名 ,b.name as 类型,
a.length as 长度, a.scale as Scale, a.isnullable as 允许空,
isnull(g.value,'') as 字段描述
from syscolumns a
join systypes b on a.xtype=b.xusertype
join sysObjects c on a.id = c.id
left join sysproperties g on a.id=g.id and a.colid=g.smallid
where c.xtype='U' and c.status>0 and a.id=object_id('某表表名')
order by c.name ASC, a.colorder