本文提供了两个SQL查询示例，用于从指定数据库表中获取列名及其对应的扩展属性值。通过使用LEFT JOIN结合sys.syscolumns与sys.extended_properties表，可以有效地检索到所需信息。
Select a.name,b.value
from sys.syscolumns a left join sys.extended_properties b
on a.id=b.major_id AND a.colid = b.minor_id
Where a.ID=OBJECT_ID('[KS_DataBase2017].[dbo].[KS_AbnormalData201709]')
Select a.name,b.value
from sys.syscolumns a left join sys.extended_properties b
on a.id=b.major_id AND a.colid = b.minor_id
Where a.ID=OBJECT_ID('[KS_DataBase2017].[dbo].[KS_DataAnalysis2017]')
from sys.syscolumns a left join sys.extended_properties b
on a.id=b.major_id AND a.colid = b.minor_id
Where a.ID=OBJECT_ID('[KS_DataBase2017].[dbo].[KS_AbnormalData201709]')
Select a.name,b.value
from sys.syscolumns a left join sys.extended_properties b
on a.id=b.major_id AND a.colid = b.minor_id
Where a.ID=OBJECT_ID('[KS_DataBase2017].[dbo].[KS_DataAnalysis2017]')
扫一扫
1823
被折叠的 条评论
为什么被折叠?
到【灌水乐园】发言
