Why not standard way by creating new field copy data delete old and rename? It can be slow operation, is it your conern to do not take production database too long offline? If yes, you can speed up such process if you have access to good hardware with a loot of RAM and do all in memory.I do not know also your setup and how complicated relations are as you can also add new field and create view which choose new field and hen you can divide this process in multiple update steeps.Regards,Karol Bieniaszewski
Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel