易丰科技
标题:
列示资料库裹的表以及栏位资料
[打印本页]
作者:
Calvin
时间:
2011-10-6 21:20
标题:
列示资料库裹的表以及栏位资料
SELECT u.name + '.' + t.name AS [table],
td.value AS [table_desc],
c.name AS [column],
cd.value AS [column_desc]
FROM sysobjects t
INNER JOIN sysusers u
ON u.uid = t.uid
LEFT OUTER JOIN sys.extended_properties td
ON td.major_id = t.id
AND td.minor_id = 0
AND td.name = 'MS_Description'
INNER JOIN syscolumns c
ON c.id = t.id
LEFT OUTER JOIN sys.extended_properties cd
ON cd.major_id = c.id
AND cd.minor_id = c.colid
AND cd.name = 'MS_Description'
WHERE upper(t.type) = upper('u')
ORDER BY t.name, c.colorder
复制代码
欢迎光临 易丰科技 (http://forum.yftek.com/)
Powered by Discuz! X3