Subject Re: [firebird-support] Rename table
Author Alain Bastien
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 GMT+04:00 liviuslivius liviuslivius@... [firebird-support] <>:


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 academic discusion that will be good to have this possibility in engine. 

If change is realy needed then i suppose simplest solusion is
Create table with same structure and run simple command

Insert into new_table
Select * from old_table
Commit and use it.

Karol Bieniaszewsli