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 date of an backup (of single specific table while sensitive operation), archival tables with year or for partitioning tables.

Query below finds all tables with digits in their names.

Confused about your SQL Server database?

You don't have to be. There's an easy way to understand the data in your databases.

I want to understand

Query

select schema_name(t.schema_id) as schema_name,
       t.name as table_name
from sys.tables t
where t.name like '%[0-9]%'
order by schema_name,
         table_name;

Columns

• schema_name - name of schema table was found in
• table_name - name of found table

Rows

• One row represents a table
• Scope of rows: all found tables
• Ordered by schema name, table name

Sample results