Karol, > 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.
With a 100GB database, the new/copy/delete approach is not feasible. Sean Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel
