查询数据字典

指定数据库中导出数据表结构：

SELECT A.Table_name ,b.Column_name,b.DATA_TYPE, b.CHARACTER_MAXIMUM_LENGTH
FROM INFORMATION_SCHEMA.TABLES A
inner join INFORMATION_SCHEMA.COLUMNS b
on b.TABLE_NAME=a.TABLE_NAME
where A.TABLE_NAME not like 'v%'
order by A.TABLE_NAME