How to display all the tables with more information (create date, size,...) in a MySQL database?

Question

Searched and searched and gave up. All I want is more info on a MySQL table or better yet, a list of all tables in a MySQL database in the descending/ascending order of their create date.

Something like this :

SHOW TABLES FROM MyDB ORDER BY CREATE_DATE;

Donnie's answer did the trick :

select * from INFORMATION_SCHEMA.TABLES where TABLE_SCHEMA = 'DBName' order by create_time desc;

Donnie · Accepted Answer · 2010-11-16 17:31:59Z

11

INFORMATION_SCHEMA.TABLES is the most easily queryable, but that doesn't have creation date. show table status does return creation date information. You can probably craft something to get the table name out of information_schema, then call show table status on each.

edited Nov 16, 2010 at 17:31

answered Nov 16, 2010 at 17:26

Donnie

47k10 gold badges67 silver badges88 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

ThinkCode Over a year ago

Well, it sure does have create_time or is it a different version? I updated the answer in the question! Thanks much!

Donnie Over a year ago

@ThinkCode - huh, I didn't think it did. Well, yay! :)

Collectives™ on Stack Overflow

How to display all the tables with more information (create date, size,...) in a MySQL database?

1 Answer 1

2 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related