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

Comments are only visible when the visitor has consented to statistics cookies. To see and add comments please accept statistics cookies.
0
There are no comments. Click here to write the first comment.