| Subject | Re: [firebird-support] Rename table |
|---|---|
| Author | Ertan Küçükoğlu |
| Post date | 2017-07-16T07:41:02Z |
Sent from my iPhone
On 16 Jul 2017, at 07:40, Alain Bastien alainbastien@... [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.
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