RENAME TABLE for Time Series Tables | Teradata Vantage - 17.10 - RENAME TABLE - Advanced SQL Engine - Teradata Database

Teradata Vantageā„¢ - Time Series Tables and Operations

Advanced SQL Engine
Teradata Database
Release Number
Release Date
July 2021
Content Type
Programming Reference
Publication ID
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.