> > > I want to change a domain NUMERIC(18,4) to NUMERIC(15,2). Is there any
> >
> >
> > You cannot. Firebird will not allow you to alter to a datatype
> > that holds less values.
>
> It allowed the change without any complains.
> Maybe because I don't have values larger than 15,2?

Erick, I just tried it, and it does allow it. I'm puzzled :-)

This fails, for example:

CREATE DOMAIN D_TEST2 AS VARCHAR(40);
ALTER DOMAIN D_TEST2 TYPE VARCHAR(20);

with message:

unsuccessful metadata update
New size specified for column D_TEST2 must be at least 40 characters.

I thought it always did that...

Martijn Tonies
Database Workbench - development tool for Firebird and more!
Upscene Productions
http://www.upscene.com
My thoughts:
http://blog.upscene.com/martijn/
Database development questions? Check the forum!
http://www.databasedevelopmentforum.com