Effects of the statement: The specified table is renamed to the new name. All privileges, constraints, and indexes on the table are preserved.
Any access plans that refer to that table are invalidated. For more information see Packages and access plans.
Considerations for aliases: If an alias name is specified for table-name, the table must exist at the current server, and the table that is identified by the alias is renamed. The name of the alias is not changed and continues to refer to the old table name after the rename.
There is no support for changing the name of an alias with the RENAME statement. To change the name to which the alias refers, the alias must be dropped and recreated.
Rename rules: The rename operation performed depends on the new name specified.
If an alias name is specified for table-name, the alias must exist at the current server, and the table that is identified by the alias is renamed. The name of the alias is not changed and continues to refer to the old table after the rename. There is no support for changing the name of an alias.
(C) Copyright IBM Corporation 1992, 2006. All Rights Reserved.