Hi Erick,

> 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.

> special instructions recommended or just an ALTER DOMAIN will do the
> job, converting all my data?
>
> I may have values with more than 2 decimals, so I think the decimals
> will be converted and the rest will be fine, right? I don't have
> numbers greater than 15 digits.
>
> Is it required/recommended to do a backup/restore after this change?

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