I have two tables where foreign key cannot be set so is it necessary to assign foreign key any way?
+1
A:
You never have to define foreign keys, but it's best practice to do so to improve the consistency of your data.
marcgg
2009-12-22 12:33:58
A:
No, it's not necessary, but usually it's convenient to have the database checks data integrity for you. Otherwise you'll need to enforce data integrity on application level.
egorius
2009-12-22 12:35:45
you need to enfore data integrity on application level whether or not the database supports constraints since if you dont do that you'll get errors because of constraints in your application.
Numenor
2009-12-22 12:57:30