on 04-29-2013 3:23 PM
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)
sp_iqrename object-name, new-name [, object-type ]
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
ALTER TABLE N.tablename RENAME N.tablename_1;
GO
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
84 | |
23 | |
11 | |
9 | |
8 | |
5 | |
5 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.