Renaming an object - SQL Prompt

SQL Prompt can create a script that allows you to rename objects in your database without breaking dependencies. You can rename the following:

SQL Prompt 5.0 Help Linked GIF File Template

Note: Renaming an object with SQL Prompt is available only in SQL Prompt Pro Edition.

When an object is renamed:

SQL Prompt also modifies any objects that reference, or are referenced by, the renamed object to ensure that dependency links are not broken.
If you have previously renamed an object using SQL Server Management Studio or Enterprise Manager Rename, or the T-SQL sp_rename command, the object definition will contain the original name. Any objects that reference this original name are not updated.

<placeholder for link to find invalid objects feature>
the original permissions and extended properties of the object are preserved.

You can rename encrypted objects in SQL Server 2000 if you are a member of the sysadmin server role; you cannot rename encrypted objects in SQL Server 2005 or 2008.

To rename an object:

On the SQL Prompt menu, click Smart Rename, or in the SQL Server Management Studio Object Explorer pane, right-click the object you want to rename and select Smart Rename.
The Smart Rename dialog box is displayed:
If you want to change the object owner, select a new owner.
Type a new name for the object.
The name you enter must not already be in use.
Click Next.
SQL Prompt creates the rename script and displays summary information:
- Actions is a summary of the actions that the script will perform, in the order in which they will occur.
- Warnings displays information that you should consider prior to running the script, including any reasons the script might fail.
- Dependencies lists objects that will be modified by the script because they reference, or are referenced by, the object being renamed.
The actions and warnings are included in the rename script, below the header. If you do not want to include this information in the script, clear the Include summary in the generated script check box.
Click View Script.
The dialog box is closed, and the rename script is displayed in a new SQL Server Management Studio query window.

You are recommended to back up your database before you run the script.
Once you have reviewed the script, run it.
You must refresh the Object Explorer list before it will display the new name.