> >>>> 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...
>
> Perhaps Erick is using a tool which manipulates system tables directly?

;-)

Well, doing the ALTER for the numeric domain is being
executed without any error messages, so, there is - apparently -
a difference between modifying numerics and others.

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