Renames an existing table.
You cannot rename a temporal table that has a system-defined single-table join index. You must first drop the system-defined join index and then rename the table.
See the following sections:
ANSI Compliance
RENAME TABLE is a Teradata extension to the ANSI SQL:2011 standard.
Required Privileges
You must have DROP privileges on the table to be renamed, and the appropriate CREATE privileges on its containing database or user.