Re: Can Check Constraints be Reused for Multiple Columns?

> > > 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.

Ah ok. Kinda makes things easier.

Still, it would be even more easy if Oracle supported domains ;-)

-- 
With regards,

Martijn Tonies
Database Workbench - tool for InterBase, Firebird, MySQL, Oracle & MS SQL
Server
Upscene Productions
http://www.upscene.com
Database development questions? Check the forum!
http://www.databasedevelopmentforum.com