SELECT a.name [column], b.name type, a.prec length, isnull(c.value, ' ') [description]
FROM syscolumns a
LEFT OUTER JOIN systypes b ON a.xusertype = b.xusertype
LEFT OUTER JOIN sys.extended_properties c ON a.id = c.major_id AND a.colid = c.minor_id
WHERE a.id = object_id('表')
ORDER BY a.colorder
sql 2008 查询表属性
最新推荐文章于 2021-05-24 10:36:21 发布