前面有寫過《MS SQL為欄位添加說明》https://www.cnblogs.com/insus/p/12106589.html
現如今，我們獲取這些欄位的描述值，
先來看一句SELECT陳述句：
SELECT * FROM sys.extended_properties GOSource Code
如上SQL陳述句，雖然得到描述的值，但我們不清楚是哪一張表，和哪一個欄位的說明，
因此，得使用系統另外物件來關聯查詢：
SELECT t.[name] AS [Table_Name],c.[name] AS [Column_Name],e.[value] AS [Column_Description] FROM sys.tables t INNER JOIN sys.columns c ON(t.[object_id] = c.[object_id]) LEFT JOIN sys.extended_properties e ON (t.[object_id] = e.[major_id] AND c.[column_id] = e.[minor_id] AND e.[name] = 'MS_Description') GOSource Code
轉載請註明出處，本文鏈接：https://www.uj5u.com/qita/228714.html
標籤：其他