获取数据库表字段备注

MySQL写法:

SELECT
    COLUMN_NAME,
    DATA_TYPE,
    COLUMN_COMMENT
FROM
    information_schema. COLUMNS
WHERE
    table_name = '表名'

 

SQL Server写法:

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
    A.name = '表名'