RENAME a table in Teradata

You can rename a table by RENAME command directly.

Syntax:
RENAME  TABLE tbl_name1 TO tbl_name2;


Examples:
RENAME TABLE tbl_emp TO tbl_employee;


With Database notification:
DATABASE EMP;
RENAME TABLE tbl_emp TO tbl_employee;