rename table

[Anonymous]

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

[swuehl]

Try using

Rename table My_Table to New_table;

, this is also what the HELP says, AFAIR.

[jeffmartins]

Hi bibopipo,

The correct syntax is :

Rename table Tab1 to Tab2;

Regards

[Anonymous]

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