SELECT
sys.tables.name AS テーブル物理名,
sys.extended_properties.value AS テーブル論理名
FROM
sys.schemas
INNER JOIN sys.tables
ON sys.tables.schema_id = sys.schemas.schema_id
LEFT JOIN sys.extended_properties
ON sys.extended_properties.major_id = sys.tables.object_id
AND sys.extended_properties.minor_id = 0
テーブル物理名
テーブル論理名
1
staff
スタッフマスタ
カラムのコメントを取得
SELECT
sys.columns.name AS カラム物理名,
sys.extended_properties.value AS カラム論理名
FROM
sys.schemas
INNER JOIN sys.tables
ON sys.tables.schema_id = sys.schemas.schema_id
INNER JOIN sys.columns
ON sys.columns.object_id = sys.tables.object_id
LEFT JOIN sys.extended_properties
ON sys.extended_properties.major_id = sys.columns.object_id
AND sys.extended_properties.minor_id = sys.columns.column_id
WHERE
sys.schemas.name = N'dbo'
AND sys.tables.name = N'staff'