mysql中查看所有表、表字段、表注释、字段注释

mysql中查看所有表、表字段、表注释、字段注释

查看所有表和表注释

select 
	TABLE_NAME,
	TABLE_COMMENT 
from 
	INFORMATION_SCHEMA.Tables
where 
	table_schema = '某数据库名称'

INFORMATION_SCHEMA.Tables:
TABLE_SCHEMA，TABLE_NAME，CREATE_TIME，UPDATE_TIME，CHECK_TIME，TABLE_COMMENT

查看所有字段和字段注释

  select 
    	COLUMN_NAME,
    	COLUMN_COMMENT 
    from 
    	INFORMATION_SCHEMA.Columns
    where 
    	table_name = '表名'  
    	and table_schema='数据库名'

INFORMATION_SCHEMA.Columns:
TABLE_SCHEMA，TABLE_NAME，COLUMN_NAME, COLUMN_TYPE, COLUMN_KEY