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
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