> >> Would you be happy with BASED ON functionality? This way, it would
> >> take only the data type and everybody's clear it's not the whole
> >> domain.
> >
> > But what happens if the datatype of the underlying column changes?
>
> You can change any constraint or default in the domain since it doesn't
> affect the BASED ON declaration. However, you can't change the data type.
> This will avoid the mismatches we are trying to prevent when one has to
> maintain currently domains and procedure parameters in sync manually.
> In the future, we could consider your request to invalidate objects.
> BASED ON is accepted by GDEF and GPRE.

So, changing the domain datatype is prohibited?

With regards,

Martijn Tonies
Database Workbench - developer tool for InterBase, Firebird, MySQL & MS SQL
Server.
Upscene Productions
http://www.upscene.com