Find tables with names that contain a specific prefix in Azure SQL Database

The query below finds tables whose names start with a specific prefix, e.g. tables with names starting with 'pr'.


select schema_name(t.schema_id) as schema_name, as table_name
from sys.tables as t
where like 'pr%'
order by 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: table name, schema 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.