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

Teradata Vantage™ - SQL Data Definition Language Syntax and Examples

Advanced SQL Engine
Teradata Database
Release Number
January 2021
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.

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.