SELECT
table_name 表名称,
table_comment 表注释
FROM
information_schema.TABLES
WHERE
table_schema = '数据库名称'
AND table_name LIKE '%表名称符合条件%'
ORDER BY
table_name
select column_name '字段名称',column_type '字段类型',is_nullable '是否为空',column_comment '字段注释'
from information_schema.columns where table_schema='数据库名称'' and table_name='表名称';