Was this page helpful?
Your feedback about this content is important. Let us know what you think.
Additional feedback?
1500 characters remaining
Export (0) Print
Expand All
Important This document may not represent best practices for current development, links to downloads and other resources may no longer be valid. Current recommended version can be found here.

How to: Undo a Database Object Rename

This topic explains how to undo the changes after you rename a database schema object. When you rename a schema object, other objects that reference the renamed object are automatically updated with the new name. For example, if you rename a column in a table, any stored procedures that reference that column are automatically updated with the new name. For more information, see Overview of Rename Refactoring.

You can use the global undo functionality to undo the changes after you rename a database schema object. You can undo the changes to the schema object and any references to the object that were updated automatically. These updates are undone in one transaction, and all files that are updated by the undo operation are saved, even if they are closed during the undo operation.

NoteNote

You can perform the undo operation only if all affected data generation plans are closed. For more information, see Troubleshooting Data Generation Issues.

To undo a rename refactoring operation

  • On the Edit menu, click Global Undo.

    The text of the menu option includes the details of the operation that will be undone. For example, the menu might say Global Undo *Rename from ShippedDate to ShippedDateAndTime. You can also click the Undo button on the toolbar. If you click the drop-down arrow on the button, the details of the operation that will be undone appear.

    If no operation can be undone, the command will be disabled and display the text Undo Last Global Action.

    NoteNote

    You can also redo operations by using Global Redo.

See Also

Show:
© 2015 Microsoft