Icon RENAME TABLE

Renames an existing table.

Syntax
RENAME TABLE <Name> TO <Name>

Usage
Use this statement to rename a table in a database.

Warning Renaming a table can cause other jobs, functions, procedures, and triggers to generate an error if they refer to the table being renamed.

Examples
-- The following statement renames the Customer
-- table to Cust.

RENAME TABLE "Customer" TO "Cust"

Required Privileges
The current user must be granted the ALTER privilege on the current database in order to execute this statement. Please see the User Security topic for more information.

SQL 2003 Standard Deviations
This statement deviates from the SQL 2003 standard in the following ways:

DeviationDetails
ExtensionThis SQL statement is an ElevateDB extension.
Image