Find recently created tables in MySQL database

Query below lists all tables in MySQL database that were created within the last 60 days

Query

select table_schema as database_name,
       table_name,
       create_time
from information_schema.tables
where create_time > adddate(current_date,INTERVAL -60 DAY)
      and table_schema not in('information_schema', 'mysql',
                              'performance_schema','sys')
      and table_type ='BASE TABLE'
      -- and table_schema = 'your database name' 
order by create_time desc,
         table_schema;

Columns

  • database_name - table owner, schema name
  • table_name - table name
  • create_time - table's creation date

Rows

  • One row represents one table in a database
  • Scope of rows: all tables in MySQL database that were created within the last 60 days
  • Ordered by table's creation date (descending) and database name

Sample results

0
There are no comments. Click here to write the first comment.