MySQL: Is it possible to list all tables with a modification date?

64 Views Asked by At

Is it possible to list all tables in a given MySQL database with the modification date in the right side?

I am looking for something like

SHOW TABLES FROM MY_DATABASE;
1

There are 1 best solutions below

5
juergen d On

You can query the tables with information_schema.tables

select table_name, 
       coalesce(update_time, create_time) as last_modified
from information_schema.tables