RENAME TABLE for Time Series Tables | Teradata Vantage - 17.00 - RENAME TABLE - Teradata Database

Teradata Vantageā„¢ - Time Series Tables and Operations

prodname
Advanced SQL Engine
Teradata Database
vrm_release
17.00
created_date
June 2020
category
Programming Reference
featnum
B035-1208-170K

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.