13 May 18 · npack ·       Add to Favorites  

Rename a table in Teradata

If you need to rename a table in the Teradata database, use the general SQL below as a template for renaming your table:

Syntax:

Rename table DATABASE.TABLECURRENT to DATABASE.TABLENEW;


Example:

Rename table db.Emp to db.Employee;


Remember,

  • to alter and refresh the views with the new table name
  • to refresh the procedures / macros after the table rename

npack

posted on 13 May 18

Enjoy great content like this and a lot more !

Signup for a free account to write a post / comment / upvote posts. Its simple and takes less than 5 seconds

Copied