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