SQL显示某表的字段名和说明备注

Select A.name As 字段名,C.value As 说明
From syscolumns A
Inner Join sysobjects B on A.id=B.id
Left Join sys.extended_properties C on A.id=c.major_id and a.colid=C.minor_id Where B.name='User_Order'

Posted in 数据库 by 傻猫 at March 20, 2017.
Tags: sql

添加新评论