Skip to Content
0
Former Member
Nov 10, 2014 at 11:04 PM

"Rename table" - Does it physically drop+create my table?

94 Views

Hi everyone,

for my current HANA SQLScript development it would be very convenient to temporarily rename tables and then re-rename them back to their original names.

Algorythmically this may obviously be solved by two "rename table" commands -

but in case my tables are huge: can I be sure that this has no impact on DB performance?

Concretely: Does the "rename table" command physically drops- and then re-creates my table?

Since I haven't found any background information on the "rename table" command neither in the HANA SQL online documentation nor in the Development Guides:

Does anyone know if "rename table" has got any HANA DB performance impact for huge tables?

Thanks & Best Regards,

Alexander