Examples

Example 1: 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

Example 2: Rename a table named MA_PROJ to MA_PROJ_94.

   RENAME TABLE MA_PROJ
     TO SYSTEM NAME MA_PROJ_94