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

Comments are only visible when the visitor has consented to statistics cookies. To see and add comments please accept statistics cookies.
There are no comments. Click here to write the first comment.