workbech - mysql 查询表结构

调整schema_name即可

 

?

1 2 3 4

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'