Mysql 数据字典

SELECT  A.TABLE_SCHEMA as 用户名,    
  A.TABLE_NAME as 表名,   
  B.TABLE_COMMENT as 表中文名,    
  B.TABLE_ROWS AS 记录数,    
  A.COLUMN_NAME as 字段名,   
  A.COLUMN_COMMENT as 字段注释,   
  A.COLUMN_TYPE as 字段类型   
FROM   information_schema.`COLUMNS` A    
LEFT JOIN information_schema.`TABLES` B ON A.TABLE_SCHEMA = B.TABLE_SCHEMA      
AND A.TABLE_NAME = B.TABLE_NAME     
WHERE B.TABLE_SCHEMA='UAP' AND B.TABLE_TYPE='BASE TABLE'      
ORDER BY A.TABLE_SCHEMA,A.TABLE_NAME,A.ORDINAL_POSITION ;