workbech - mysql 查询表结构

调整schema_name即可

 

SELECT  t.TABLE_NAME AS 表名,  t.TABLE_COMMENT AS 表注释,  
c.COLUMN_NAME AS 字段名,  c.COLUMN_TYPE AS 数据类型,  c.COLUMN_COMMENT AS 字段注释  
FROM  INFORMATION_SCHEMA.TABLES AS t,  INFORMATION_SCHEMA.COLUMNS AS c 
 WHERE  c.TABLE_NAME = t.TABLE_NAME and   t.TABLE_NAME like '%xxx%' AND t.TABLE_SCHEMA = 'schema_name'