Re: Can Check Constraints be Reused for Multiple Columns?

From: Tony Andrews <andrewst_at_onetel.com>
Date: 11 Aug 2005 04:36:31 -0700
Message-ID: <1123760191.595702.151640@g43g2000cwa.googlegroups.com>

Martijn Tonies wrote:
> > Oracle does have them, in their Case products, like Designer.
>
> How would they be implemented, not as schema objects, correct?

Oracle Designer domains can be used to generate DDL for check constraints. You could create a domain called YN with valid values 'Y' and 'N', and then define a table with columns associated with that domain. On generating DDL for the table, Designer would create a check constraing of the form "CHECK (xxx IN ('Y','N'))" for each column associated with the YN domain.

So it has no bearing on the final schema objects, just makes it easier to set them up. Received on Thu Aug 11 2005 - 06:36:31 CDT