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 specific table while performing a sensitive operation), archival tables with year or for partitioning tables.
The query below finds all tables with digits in their names.
select schema_name(t.schema_id) as schema_name, t.name as table_name from sys.tables as t where t.name like '%[0-9]%' order by schema_name, table_name;
- schema_name - name of the 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: schema name, table name