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
nVector
posted on 13 May 18Enjoy 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
Post Comment