is it possible to rename a table ? In my script I'm trying the following
Rename table My_Table as New_table;
but it doesn't work. The manual gives the same syntax, but it doesn't work properly.
Any suggestions ?
Thanks in advance for your support
Rename table My_Table to New_table;
, this is also what the HELP says, AFAIR.
Thanks very much!!!
What I've in my HELP is the following: in the first case is mentioned "as" instead "to". Perhaps it's a mistake.
Select * from Trans;
Rename table Tab1 as Xyz;
Mapping load oldnames, newnames from tabnames.csv;
Rename tables using TabMap;
The correct syntax is :
Rename table Tab1 to Tab2;
Retrieving data ...