SELECT
TABLE_NAME 表名,
TABLE_COMMENT 描述
FROM
INFORMATION_SCHEMA.TABLES
WHERE
TABLE_TYPE = 'BASE TABLE'
AND TABLE_SCHEMA = '数据库名'
ORDER BY
TABLE_NAME ASC
也可以直接在information_schema库的TABLES表里面查看
SELECT
TABLE_NAME 表名,
TABLE_COMMENT 描述
FROM
INFORMATION_SCHEMA.TABLES
WHERE
TABLE_TYPE = 'BASE TABLE'
AND TABLE_SCHEMA = '数据库名'
ORDER BY
TABLE_NAME ASC
也可以直接在information_schema库的TABLES表里面查看