The RENAME statement renames a table, view, or index. The name and/or the system object name of the table, view, or index can be changed.
Rename a table named MY_IN_TRAY to MY_IN_TRAY_94. The system object name will remain unchanged (MY_IN_TRAY).
RENAME TABLE MY_IN_TRAY TO MY_IN_TRAY_94 FOR SYSTEM NAME MY_IN_TRAY
For more information, see RENAME in the SQL Reference topic in the
Information Center.