查询各数据库表字段注释、及表对应的字段类型

PS:TABLE_NAME为数据库表名。

sqlserver:

1.查看表结构
SELECT TABLE_NAME, COLUMN_NAME, DATA_TYPE
FROM INFORMATION_SCHEMA.COLUMNS
WHERE TABLE_NAME = 'EN_RENEW_CHARGE'
ORDER BY ORDINAL_POSITION
2.查看表字段注释
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 = 'EN_RENEW_CHARGE'