多表结构导出SQL

# 第一种：多表结构导出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';