>>>> 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? ;-)

Sorry, could not resist. ;-)


--
Best Regards,
Thomas Steinmaurer
LogManager Series - Logging/Auditing Suites supporting
InterBase, Firebird, Advantage Database, MS SQL Server and
NexusDB V2
Upscene Productions
http://www.upscene.com