Renaming Objects

Last modified: October 23, 2019

The Rename functionality provides an easy way to change an object name for a new one that better reveals its purpose and automatically finds and corrects all references to it.

You can rename an object only in a script, and not in a database.

The Rename refactoring is available for:

Tables
Views
Stored procedures
Packages
Functions
Triggers
Sequences
User types
Materialized views
Synonyms
Clusters

To rename an object in the SQL editor:

Right-click the required object and select the Rename command on the shortcut menu. Alternatively, you can select the object and press F2. The object will be highlighted.
Type a new name for the object in the SQL editor window. As you type, a tooltip appears instructing to Press F2 to preview changes or Enter/Tab to apply.
Press F2 to open the Preview Changes - Rename dialog window and preview code changes, to apply changes press the Apply button;
Alternatively, press Enter/Tab to apply changes in the code.