MySql 查询数据库中所有表名

//查询数据库中所有表名、创建时间、数据库引擎、字符集、表描述，创建时间降序排序
select table_name ,create_time , engine, table_collation, table_comment from information_schema.tables where table_schema = (select database()) order by create_time desc