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
  • Triggers
  • Logins
  • Types
  • Rules
  • Sequences
  • Synonyms

To rename an object in the SQL editor:

  1. Right-click the required object and select the Rename command from the shortcut menu. Alternatively you can select the object, go to the SQL Complete menu and select the Rename command or 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.