Subject | Re: [firebird-support] Rename table |
---|---|
Author | Alain Bastien |
Post date | 2017-07-17T15:05:35Z |
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] <firebird-support@yahoogroups.com>:
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 academic discusion that will be good to have this possibility in engine.If change is realy needed then i suppose simplest solusion isCreate table with same structure and run simple commandInsert into new_tableSelect * from old_tableCommit and use it.Regards,Karol Bieniaszewsli