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'.

    Query

    select schema_name(t.schema_id) as schema_name,
           t.name as table_name
    from sys.tables as t
    where t.name like 'pr%'
    order by table_name,
             schema_name;
    

    Columns

    • schema_name - name of the schema where the table was found
    • table_name - name of the table found

    Rows

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

    Sample results

    0
    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.
    Accept