Description

TABLE table-name or view-name
Identifies the table or view that will be renamed. The table-name or view-name must identify a table or view that exists at the current server, but must not identify a catalog table or a global temporary table. The specified name can be an alias name. The specified table or view is renamed to the new name. All privileges, constraints, indexes, triggers, views, and logical files on the table or view are preserved.

Any access plans that reference the table or view are implicitly prepared again when a program that uses the access plan is next run. Since the program refers to a table or view with the original name, if a table or view with the original name does not exist at that time, an error is returned.

INDEX index-name
Identifies the index that will be renamed. The index-name must identify an index that exists at the current server. The specified index is renamed to the new name.

Any access plans that reference the index are not affected by rename.

new-table-identifier
Identifies the new table-name, view-name, or index-name of the table, view, or index, respectively. new-table-identifier must not be the same as a table, view, alias, or index that already exists at the current server. The new-table-identifier must be an unqualified SQL identifier.
SYSTEM NAME system-object-identifier
Identifies the new system-object-identifier of the table, view, or index, respectively. system-object-identifier must not be the same as a table, view, alias, or index that already exists at the current server. The system-object-identifier must be an unqualified system identifier.

If the name of the object and the system name of the object are the same and new-table-identifier is not specified, specifying system-object-identifier will be the new name and system object name. Otherwise, specifying system-object-identifier will only affect the system name of the object and not affect the name of the object.

If both new-table-identifier and system-object-identifier are specified, they cannot both be valid system object names.