13 May 18 · npack ·       Add to Favorites   Report

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

Read great educational content like this and a lot more !

Members get free exclusive access to content, new courses, and discounts. Signup for a free account to write a post / comment / upvote posts. Creating an account takes less than 5 seconds and you can start earning badges & points too

Copied