RENAME TABLE Statement | Teradata Vantage - 17.00 - RENAME TABLE - Advanced SQL Engine - Teradata Database

Teradata Vantage™ - SQL Data Definition Language Syntax and Examples

Advanced SQL Engine
Teradata Database
Release Number
September 2020
Content Type
Programming Reference
Publication ID
English (United States)

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.

Required Privileges

You must have DROP privileges on the table to be renamed, and the appropriate CREATE privileges on its containing database or user.