檢索數(shù)據(jù)庫架構(gòu)信息 – ADO.NET | Microsoft 官方文檔

將系統(tǒng)表映射到系統(tǒng)視圖 (Transact-sql) – SQL Server | Microsoft 官方文檔

一、注釋中帶某關(guān)鍵字的對(duì)象（sys.extended_properties）

主要用到 sys.tables 、sys.columns 、sys.procedures  系統(tǒng)對(duì)象表以及sys.extended_properties 擴(kuò)展屬性表

–查詢列
SELECT A.name AS table_name ,
B.name AS column_name ,
C.value AS column_description
FROM sys.tables A
INNER JOIN sys.columns B ON B.object_id = A.object_id
LEFT JOIN sys.extended_properties C ON C.major_id = B.object_id
AND C.minor_id = B.column_id
WHERE CAST(C.[value] AS VARCHAR(1000)) LIKE ‘%年假%’;

–查詢表
SELECT A.name AS table_name ,
C.value AS column_description
FROM sys.tables A
INNER JOIN sys.extended_properties C ON C.major_id = A.object_id
AND C.minor_id = 0
WHERE CAST(C.[value] AS VARCHAR(1000)) LIKE ‘%請(qǐng)假%’

–查詢存儲(chǔ)過程
SELECT A.name AS table_name ,
C.value AS column_description
FROM sys.procedures A
INNER JOIN sys.extended_properties C ON C.major_id = A.object_id
AND C.minor_id = 0
WHERE CAST(C.[value] AS VARCHAR(1000)) LIKE ‘%年假%’