Test If Your Database Has Foreign Keys Or Is It Full of Loners (Metric + Test Queries)
Databases should but many don't have foreign key constraints. Does your database have them? To what extent? Here is a me...
Dataedo Academy
About Dataedo
Contact Us
Dataedo Academy
After Hours
Learn about Dataedo
Latest post: 8 Best Microsoft Purview Alternatives for Data Governance (2026)Articles tagged: Foreign Keys
Databases should but many don't have foreign key constraints. Does your database have them? To what extent? Here is a me...
Results of my research of existence of foreign key constraints in 40 example databases.
My research revealed that most major ERP and CRM applications do not use foreign key constraints in their databases.
A compilation of reasons why databases don't have defined foreign keys.
There are 2 very common traps (with serious consequences) you can easily fall into while joining tables in an SQL query....