> > Perhaps Erick is using a tool which manipulates system tables directly?

;-)

>
> I've used IBExpert, but I don't think it's manipulating system tables
> without telling me. :)
> I did not enable the option to allow it.
>
> I think the command it sent to the database was a simple:
>
> ALTER DOMAIN MY_DOMAIN TYPE NUMERIC(15,2);
>
> And it worked.

Erick, try NUMERIC(8, 2)

I bet it comes back with something like:

unsuccessful metadata update
Cannot change datatype for D_TEST. Conversion from base type BIGINT to
INTEGER is not supported.



it seems that as long as the underlying datatype doesn't change
to something smaller, it's allowed.

Martijn Tonies
Database Workbench - tool for InterBase, Firebird, MySQL, NexusDB, Oracle &
MS SQL Server
Upscene Productions
http://www.upscene.com
My thoughts:
http://blog.upscene.com/martijn/
Database development questions? Check the forum!
http://www.databasedevelopmentforum.com