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

Teradata Vantage™ Time Series Tables and Operations

Product
Teradata Database
Teradata Vantage NewSQL Engine
Release Number
16.20
Release Date
March 2019
Content Type
Programming Reference
Publication ID
B035-1208-162K
Language
English (United States)

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;