Ask the Expert

More on exclusive OR subtypes

This is in response to your reply to the question about exclusive OR subtypes (posted 17 Sep 2002). You stated that you don't know of any declarative way to enforce this. I believe that check constraints can be placed on each of the dependent tables to prevent inserts or updates that create a row that has the same foreign key value that is already in any of the other dependent tables. I consider check constraints to be declarative statements.

    Requires Free Membership to View

This was first published in September 2002

There are Comments. Add yours.

TIP: Want to include a code block in your comment? Use <pre> or <code> tags around the desired text. Ex: <code>insert code</code>

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy
Sort by: OldestNewest

Forgot Password?

No problem! Submit your e-mail address below. We'll send you an email containing your password.

Your password has been sent to: