目录
库的表及注释
查看某个数据库所有表及注释:
SELECT
TABLE_NAME,
TABLE_COMMENT
FROM
INFORMATION_SCHEMA. TABLES
WHERE
table_schema = 'dbName';
表的字段及注释
查看某张表的字段及注释:
SELECT
table_name,COLUMN_NAME,COLUMN_COMMENT
FROM
INFORMATION_SCHEMA. COLUMNS
WHERE
table_name = 'tableName'
AND table_schema = 'dbName'
库所有表所有字段及注释
SELECT
table_name,
COLUMN_NAME,
COLUMN_COMMENT
FROM
INFORMATION_SCHEMA. COLUMNS
WHERE
table_name IN (
SELECT
TABLE_NAME
FROM
INFORMATION_SCHEMA. TABLES
WHERE
table_schema = 'dbName'
)
AND table_schema = 'dbName'