SELECT a.name column_name , b.name column_type, a.prec column_length, isnull(c.value, ' ') column_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('Table_name')
sql 查看数据库表中字段备注信息
最新推荐文章于 2024-02-03 11:16:48 发布