sql databse relationships architecture?

Question

Hi im arslan ,
i have seen first time ever sql database tables working without foreign key relation in big project .
what is the best practise to use relational database ,1 with foreign keys . 2 without foreign keys?

Answer 1

Hi @Arslan Abbasi ,

Foreign key.
Foreign key constraints are as essential to a relational database as are tables and columns
The obvious problem with the lack of foreign keys is that a database can not enforce referential integrity, and tables relations are not clear

-------------

If the answer is the right solution, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".

Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

Answer 2

With foreign keys!

There are people who say "oh, we manage this in the application". Which often results in orphan rows and other sorts of inconsistencies.