List databases, tables, columns in MySQL

List of databases,tables,columns in MySQL :

The following statements are successfully executed to find out the how many tables are used in database and which types of the data are used.


   SELECT

  t.table_schema AS 'Database'

  ,t.table_name AS 'Table'

  ,t.table_type AS 'Table Type'

  ,c.column_name AS 'Column'

  ,c.data_type AS 'Data Type'

FROM information_schema.tables t

JOIN information_schema.columns c ON t.table_schema = c.table_schema AND t.table_name = c.table_name

WHERE t.table_schema NOT IN( 'mysql','information_schema')

ORDER BY t.table_schema,t.table_type,t.table_name,c.ordinal_position;

Output :