檢索數據庫架構信息 – ADO.NET | Microsoft 官方文檔

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

一、注釋中帶某關鍵字的對象（sys.extended_properties）

主要用到 sys.tables 、sys.columns 、sys.procedures  系統對象表以及sys.extended_properties 擴展屬性表

–查詢列
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 ‘%請假%’

–查詢存儲過程
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 ‘%年假%’