Renaming Database Objects

You can use database refactoring to rename a database schema object in Microsoft Visual Studio Team Edition for Database Professionals. Other objects that reference the renamed object are automatically updated with the new name. For example, you can rename a column in a table, and any stored procedures that reference that column are automatically updated with the new name.

In This Section

• Overview of Rename Refactoring
  Provides an overview of how you can rename a database schema object and describes the effect on other objects in the database project.

• Considerations before Renaming Database Objects
  Discusses important issues to consider before you rename database objects, such as how to prevent data loss, and describes the effects on data generation plans and scripts.

• Protecting Data during a Renaming Operation
  Discusses options to prevent possible data loss when you rename a database object.

• Rename Refactoring Tasks
  Contains links to information about common rename refactoring tasks such as renaming database objects, previewing rename operations, and reversing rename operations.

Related Sections

• Refactoring Database Objects in a Team Environment
  Discusses things to consider when you refactor database objects in a team environment.

• Deploying Refactoring Changes to a Database
  Discusses how to deploy refactoring changes to a database.

• Terminology Overview of Database Edition
  Describes terminology associated with the features of Visual Studio Team System Database Edition.