Find tables without foreign keys in Azure SQL Database

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

Table of Contents:

    The query below lists all tables that do not have foreign keys.

    See also:


    select schema_name(fk_tab.schema_id) as schema_name, as table_name,
        '>- no FKs' foreign_keys
    from sys.tables as fk_tab
        left outer join sys.foreign_keys as fk
            on fk_tab.object_id = fk.parent_object_id
    where fk.object_id is null
    order by schema_name(fk_tab.schema_id),


    • schema_name - name of the schema
    • table_name - name of the table
    • foreign_keys - symbol indicating the lack of FKs


    • One row: represents one table that doesn't have a foreign key
    • Scope of rows: all tables in a database that don't have foreign keys (do not refer to other tables)
    • Ordered by: schema and table name

    Sample results

    List of tables in the AdventureWorksLT without foreign keys:

    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.