Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Dear all,
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
Try using
Rename table My_Table to New_table;
, this is also what the HELP says, AFAIR.
Hi bibopipo,
The correct syntax is :
Rename table Tab1 to Tab2;
Regards
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.
Tab1:
Select * from Trans;
Rename table Tab1 as Xyz;
TabMap:
Mapping load oldnames, newnames from tabnames.csv;
Rename tables using TabMap;
stefan