title: How to display all the tables with more information (create date, size,...) in a MySQL database?
body: <p>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.</p>
  
  <p>Something like this :</p>
  
  <pre><code>SHOW TABLES FROM MyDB ORDER BY CREATE_DATE;
  </code></pre>
  
  <p>Donnie's answer did the trick :</p>
  
  <pre><code>select * from INFORMATION_SCHEMA.TABLES where TABLE_SCHEMA = 'DBName' order by create_time desc;
  </code></pre>