RENAME a table in Teradata

  1. Forget Code
  2. Teradata
  3. RENAME a table
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;