Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

rename table

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

3 Replies
swuehl
MVP
MVP

Try using

Rename table My_Table to New_table;

, this is also what the HELP says, AFAIR.

jeffmartins
Partner - Creator II
Partner - Creator II

Hi bibopipo,

The correct syntax is :

Rename table Tab1 to Tab2;

Regards

Anonymous
Not applicable
Author

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