Renaming Objects

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:

  1. 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.

  2. 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.

  3. Press F2 to open the Preview Changes - Rename dialog window and preview code changes, to apply changes press the Apply button;

  4. Alternatively, press Enter/Tab to apply changes in the code.

Want to Find out More?

Overview

Overview

Take a quick tour to learn all about the key benefits delivered by dbForge Studio for Oracle.
All Features

All features

Get acquainted with the rich features and capabilities of the Studio in less than 5 minutes.
Request a demo

Request a demo

If you consider employing the Studio for your business, request a demo to see it in action.
Ready to start using dbForge Studio for Oracle?