Rename Clause
Purpose
Use the Rename clause to rename an existing table. It is optional.
Syntax
RENAME TO new_name
where:
new_name
specifies the new name for the table.
Example A
This example renames the table to test2.
ALTER TABLE test RENAME TO test2
