Qualifying an Object from Another Database
To rename a table that is not contained in the same database or user as your current default database setting, you must qualify both the old and new names with the name of the containing database or user for the object.
You cannot change the immediate owner of the renamed object using this statement.
Locks and Concurrency
When a table is renamed, an EXCLUSIVE lock is placed on the item being renamed.
Renaming Volatile and Global Temporary Tables
You cannot rename a volatile table.
You can rename a global temporary table only when there are no materialized instances of that table anywhere in the system.
Tables with Join Indexes
You cannot rename a table on which a join index is defined. You must first drop the index, and then you can rename the table.
Function on RENAME Table Requests
When you rename a table, Vantage only changes the table name. All statistics and privileges associated with the table remain with the table under the new name.