Re: Foreign key constraints with constant values?

From: Jared Still <jkstill@xxxxxxxxx>
To: toon.koppelaars@xxxxxxxxxxx
Date: Tue, 26 Oct 2010 11:36:56 -0700

On Tue, Oct 26, 2010 at 11:10 AM, Toon Koppelaars <
toon.koppelaars@xxxxxxxxxxx> wrote:

>
> I  know, i know, you'll now say: "but I don't want to create a seperate
> ID's - table per TYPE."
>
Why not? If you do, you can use the declarative FK to ensure data integrity.
> If you don't, SQL's support for declarative constraints won't be able to
> help you out.
>
>
Another of my favorite arguments for this:

Changes to app behavior then become DML, rather than DDL.

Jared Still
Certifiable Oracle DBA and Part Time Perl Evangelist
Oracle Blog: http://jkstill.blogspot.com
Home Page: http://jaredstill.com

Follow-Ups:

Re: Foreign key constraints with constant values?
From: Michael Moore

References:
- Foreign key constraints with constant values?
  - From: Octavian Rasnita
- Re: Foreign key constraints with constant values?
  - From: Toon Koppelaars

Re: Foreign key constraints with constant values?

Other related posts: