# 第一种:多表结构导出SQL
SELECT
T.TABLE_NAME,
T.COLUMN_NAME,
T.DATA_TYPE,
T.CHARACTER_MAXIMUM_LENGTH,
T.NUMERIC_PRECISION,
T.COLUMN_TYPE,
T.IS_NULLABLE
FROM
INFORMATION_SCHEMA. COLUMNS T
WHERE
T.TABLE_NAME IN ('SYS_USER','SYS_DEPT')
# 第二种:SQL 语句导出整个库的表、字段中英文名称
SELECT
A.TABLE_NAME as "表英文名称",
A.TABLE_COMMENT as "表中文名称",
B.COLUMN_NAME as "表字段英文名称",
B.COLUMN_COMMENT as "表字段中文名称"
FROM
INFORMATION_SCHEMA.TABLES as A ,INFORMATION_SCHEMA.COLUMNS as B
WHERE
B.TABLE_SCHEMA = 'data_report_test';