Tables usually do not have digits in their names, and if they do, they have a special meaning. We use them to name backup tables with the date of a backup (of a single specific table while performing a sensitive operation), archival tables with year or for partition tables.
The queries below find all tables with digits in their names in all databases (schemas).
select table_schema as database_name, table_name from information_schema.tables where table_type = 'BASE TABLE' and table_name rlike ('[0-9]') order by table_schema, table_name;
- database_name - name of the database (schema) where the table was found
- table_name - name of the table found
- One row: represents a table
- Scope of rows: all found tables
- Ordered by: database (schema) name, table name