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