for example we have table t1 under schema s1. can I rename it to s2.t2 with one command.currently I can do:alter table s1.t1 set schema s2;alter table s2.t1 rename to t2.
No. AFAIK alter table is the obly sql command that can do those things and the syntax does not provide a way to combine the two into a single executable command.
Out of curosity, why do you ask?
David J.
