Find tables without foreign keys in Azure SQL Database

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.