1.包括表注释、字段属性等等。
SELECT a.table_name 表名,b.table_COMMENT, a.COLUMN_NAME 列名,
a.COLUMN_TYPE 数据类型, a. DATA_TYPE 字段类型, a.CHARACTER_MAXIMUM_LENGTH 长度,
a.IS_NULLABLE 是否为空, a.COLUMN_DEFAULT 默认值, a.COLUMN_COMMENT 备注 FROM (SELECT
table_name, COLUMN_NAME, COLUMN_TYPE, DATA_TYPE, CHARACTER_MAXIMUM_LENGTH, IS_NULLABLE,
COLUMN_DEFAULT, COLUMN_COMMENT FROM INFORMATION_SCHEMA.COLUMNS where table_schema ='scs2' and
table_name in(select table_name from information_schema.tables where table_schema='scs2' )) A join (select table_name,table_COMMENT
from information_schema.tables where table_schema='scs2' )b on a.table_name = b.table_name