Hello Claudio,

> > So, changing the domain datatype is prohibited?
>
> Why do you ask? I wrote
> > However, you can't change the data type.

I wanted to make sure.

> I think I was clear: the objective of the feature BASED ON is to keep
> domains data types in sync with other usages like procedure params and
> variables, without going into endless discussions about constraints. To be
> in sync, the engine must complain if a change is attempted in the domain.
> Otherwise, what's the objective and value of the feature?

If you cannot change the domain, what is the use of this feature in
the first place? I mean, isn't the use of domains in SPs meant to
keep things the same (datatypes) if you change the domain. Heck,
this is the use for it in the tables, right?

With regards,

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