cancel
Showing results for 
Search instead for 
Did you mean: 

How to rename a table in Sybase IQ

Former Member
0 Kudos

How to rename a table in Sybase IQ.

i have a select comand like...

select * from "N"."tablename" (WHAT IS N means in the query, i need to change table name to tablename_1)

Accepted Solutions (1)

Accepted Solutions (1)

saroj_bagai
Contributor
0 Kudos

sp_iqrename object-name, new-name [, object-type ]

Answers (1)

Answers (1)

0 Kudos

ALTER TABLE N.tablename RENAME N.tablename_1;

GO