12

I know that SQL Server doesn't support using a view as the reference for a foreign key constraint, is there a reason (i.e. something to do with the relational model) this is the case? It seems like it would be useful....

13

There's no fundamental problem with doing this, since tables and views are both relation variables in the relational model. Foreign key constraints are just a particular subclass of general constraints, which standard SQL implements using CREATE ASSERTION so there's no particular SQL language difficulty either.

According to this Connect item (no longer available, and not archived) it's simply a matter of prioritization. If you would find this feature useful, vote for the item and particularly add details of your use case in the comments.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.