RENAME TABLE Command

Example   See Also

Renames a table in the current database.

Syntax

RENAME TABLE TableName1 TO TableName2

Arguments

TableName1

Specifies the name of the table to be renamed.

TableName2

Specifies the new name of the table.

Remarks

You cannot use RENAME TABLE to change the name of a free table; use RENAME instead.