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

Rene Castro - Dataedo Team Rene Castro 2018-12-10

Table of Contents:

    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

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

    By continuing to use our website, you consent to the use of cookies in accordance with our Privacy Policy.