How to generate Data dictionary in MySql

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 = '<database name>' 
order by t.table_schema, t.table_name, c.ordinal_position