MySQL information_schema

 

 

1. select table_name,table_type,engine from information_schema.tables where table_schema=`database_name` order by table_name desc;