Purpose

Renames an existing table. It is optional.

Syntax

RENAME TO new_name

where:

new_name
specifies the new name for the table.

Example

This example renames the table to test2.

ALTER TABLE test RENAME TO test2