查看“︁MySQL:导出数据字典”︁的源代码

<source lang="sql">
select t.table_schema as db_name,
  t.table_name,
  (case when t.table_type = 'BASE TABLE' then 'table'
        when t.table_type = 'VIEW' then 'view'
        else t.table_type
   end) as table_type,
   c.column_name,
   c.column_type,
   c.column_default,
   c.column_key,
   c.is_nullable,
   c.extra,
   c.column_comment
from information_schema.tables as t
inner join information_schema.columns as c
on t.table_name = c.table_name
and t.table_schema = c.table_schema
where t.table_type in('base table', 'view')
and t.table_schema like '%'
and t.TABLE_SCHEMA = 'xx_db'
order by t.table_schema, t.table_name, c.ordinal_position

</source>

[[Category:Database]]