Subject RE: [Firebird-Architect] Feature Request: Domains in SP & Triggers.
Author Claudio Valderrama C.
Martijn Tonies wrote:
>>
>> 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.

C.