SQL Refactor Studio can generate a script that allows you to rename objects in your database without breaking dependencies.
You can rename the following:
- Tables (including columns)
- Stored procedures
When an object is renamed:
- SQL Refactor Studio also modifies any objects that reference, or are referenced by, the renamed object to ensure that dependency links are not broken.
- The original permissions and extended properties of the object are preserved.
To rename an object:
In Object Explorer pane right-click the object you want to rename. In the rightclick menu, choose SQL Refactor Studio -> Rename menu command. The Rename dialog window is displayed:
Type a new name for the object.
The name you enter must not already be in use.
Click Generate rename scripts.
SQL Refactor Studio creates the rename script in a new SQL Server Management Studio query window.
Once you have reviewed the script, run it.
You must refresh the Object Explorer list before it will display the new name.