Find tables with a specific column name in Azure SQL Database

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

Table of Contents:


    The query below finds all tables that have the 'ProductID' column.

    See also tables that don't have a column with specific name.

    Query

    select schema_name(t.schema_id) as schema_name,
           t.name as table_name
    from sys.tables as t
    where t.object_id in 
        (select c.object_id 
          from sys.columns as c
         where c.name = 'ProductID')
    order by schema_name,
             table_name;
    

    Columns

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

    Rows

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

    Sample results

    List of tables that have the 'ProductID' column.

    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