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

Teradata Vantage™ - SQL Data Definition Language Syntax and Examples

Product
Advanced SQL Engine
Teradata Database
Release Number
17.10
Release Date
July 2021
Content Type
Programming Reference
Publication ID
B035-1144-171K
Language
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.