Re: [firebird-support] Rename table

this was the solution I proposed in first instance. Else what's in a name ? , if not what the table contains ? The VCL BATCHMOVE does it fast a seemlessly in one click, if field names are the same or if different then use the EMS components !!! 2017-07-17 11:48

Re: [firebird-support] Rename table

Hi, This whole discussion is strange to me.Rename table while are pending inserts to it?How. If statment like rename table exsist then after name has changed all applications must be recompiled to take this new name into account. This looks to me that discussion is not about real problem. Only

Re: [firebird-support] Rename table

then just make a BATCHMOVE (keep source) to test the time taken. surely less time. test integrity of data in the Target Table Drop the Old full table. I think a backup and restore will been necessary if there are millions of rows!!! Cheers 2017-07-16 13:53 GMT+04:00 Ertan Küçükoğlu

Re: [firebird-support] Rename table

Sent from my iPhone > On 16 Jul 2017, at 11:58, Alain Bastien alainbast...@gmail.com > [firebird-support] wrote: > > Else "What's in a NAME?" > > > > > > > > 2017-07-16 12:47 GMT+04:00 Alain Bastien : >> Hi, >> >> Block data

Re: [firebird-support] Rename table

Hi, Block data entrance ? I have never tested a situation where data is entering a database/ table and I rename a single field , or column or table and even the Database itself Can you please guest or anticipate the respond of the server's or the application's error handling and/or exceptions ?

Re: [firebird-support] Rename table

Else *"What's in a NAME?" * 2017-07-16 12:47 GMT+04:00 Alain Bastien : > Hi, > > Block data entrance ? > > I have never tested a situation where data is entering a database/ table > and I

Re: [firebird-support] Rename table

Sent from my iPhone > On 16 Jul 2017, at 07:40, Alain Bastien alainbast...@gmail.com > [firebird-support] wrote: > > Create a new table with same structure from METADATA > > Use "Batchmove" (In Delphi VCL) with Delete Source enabled > > Connect the two

[firebird-support] Rename table

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 Alain Bastien 34, Dr Ross Avenue ROSE HILL 72102 MAURITIUS Skype: