查看数据库下所有表+表名
SELECT TABLE_NAME,TABLE_COMMENT FROM information_schema.TABLES WHERE table_schema='funds_route';
查看数据表所有字段注释
SELECT column_name,column_comment,column_type,is_nullable,column_default
FROM information_schema.Columns WHERE table_schema='funds_route' and table_name='t_match_request';
数据库下所有表名+表结构注释
SELECT t.TABLE_NAME,t.TABLE_COMMENT,c.COLUMN_NAME,c.COLUMN_TYPE,c.COLUMN_COMMENT
FROM information_schema.TABLES t,INFORMATION_SCHEMA.Columns c WHERE c.TABLE_NAME=t.TABLE_NAME AND t.TABLE_SCHEMA='funds_route';
网友评论