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;