SqlServer 获取表以及表的说明

发布时间：2020-12-12 12:58:20 所属栏目：MsSql教程来源：网络整理

导读：select? ? ROW_NUMBER() OVER (ORDER BY a.object_id) AS No,? ? a.name AS Name, ? isnull(g.[value],'无') AS Remark from ? sys.tables a left join sys.extended_properties g ? on (a.object_id = g.major_id AND g.minor_id = 0) ? where a.name not i

select?

? ROW_NUMBER() OVER (ORDER BY a.object_id) AS No,?
? a.name AS Name,
? isnull(g.[value],'无') AS Remark
from
? sys.tables a left join sys.extended_properties g

? on (a.object_id = g.major_id AND g.minor_id = 0)

? where a.name not in('sysdiagrams','ASPStateTempSessions','ASPStateTempApplications');

（编辑：李大同）

【声明】本站内容均来自网络，其相关言论仅代表作者个人观点，不代表本站立场。若无意侵犯到您的权利，请及时与联系站长删除相关内容!

SqlServer 获取 表 以及 表的 说明

SqlServer 获取表以及表的说明