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:
Rename table DATABASE.TABLECURRENT to DATABASE.TABLENEW;
Rename table db.Emp to db.Employee;
- to alter and refresh the views with the new table name
- to refresh the procedures / macros after the table rename
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