16.20 - RENAME TABLE - Teradata Database - Teradata Vantage NewSQL Engine

Teradata Vantage™ Time Series Tables and Operations

Teradata Database
Teradata Vantage NewSQL Engine
Release Number
March 2019
Content Type
Programming Reference
Publication ID
English (United States)
Last Update

You can use the RENAME TABLE statement to rename PTI tables. For complete information about RENAME TABLE syntax, see Teradata Vantage™ SQL Data Definition Language Syntax and Examples, B035-1144.

You cannot rename volatile tables that have a Primary Time Index.

You can only rename global temporary table that has a Primary Time Index when there are no materialized instances of that table anywhere in the system.

Example: Rename a PTI Table

The statement below renames the table ts_table to ts_table_new.

RENAME TABLE ts_table as ts_table_new;