Sent from my iPhone > On 16 Jul 2017, at 07:40, Alain Bastien alainbast...@gmail.com > [firebird-support] <firebird-support@yahoogroups.com> wrote: > > Create a new table with same structure from METADATA > > Use "Batchmove" (In Delphi VCL) with Delete Source enabled > > Connect the two tables, MOVE DATA > > Drop the empty table. > > COMMIT!!! > > This would take merely 15 minutes > Hi,
If table is a big one with millions of rows, 15min cannot be enough moreover down time might not be possible as you should block data entrance while doing that. Regards, Ertan > > Alain Bastien > 34, Dr Ross Avenue > ROSE HILL 72102 > MAURITIUS > Skype: alainbastien > Phone: 230 57 19 30 30 > Res :230 464 68 30 > > Sent from iPhone > > >