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
  • Temporary tables and columns
  • Views
  • Stored procedures
  • Functions

To rename an object in the SQL editor:

  1. Right-click the required object and select the Rename command from the shortcut menu. Alternatively, 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.