Query below lists all tables in MariaDB 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 MariaDB database that were created within the last 60 days
• Ordered by table's creation date (descending) and database name

Sample results