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:

Comments are only visible when the visitor has consented to statistics cookies. To see and add comments please accept statistics cookies.
There are no comments. Click here to write the first comment.