Renames an existing table.
You cannot rename a temporal table if it has a system-defined single-table join index. You must first drop the system-defined join index and then rename the table. See Teradata Vantage™ - Temporal Table Support , B035-1182 for further information.
RENAME TABLE is a Teradata extension to the ANSI SQL:2011 standard.
You must have DROP privileges on the table to be renamed, and the appropriate CREATE privileges on its containing database or user.