Find tables with digits in their names in Azure SQL Database

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, as table_name
from sys.tables as t
where like '%[0-9]%'
order by schema_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

Sample results

There are no comments. Click here to write the first comment.