mssql获取表名及注释的SQL

2015-11-11 我好笨

SELECT obj.name AS [TableName],pro.value AS [Description] FROM sys.objects obj LEFT JOIN sys.extended_properties pro

ON obj.object_id=pro.major_id

WHERE obj.type='u'

有个缺点就是把字段注释也取到了。

发表评论：