This documentation is archived and is not being maintained.

Renaming Database Objects

Visual Studio 2005

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 Team Edition for Database Professionals

Describes terminology associated with the features of Team Edition for Database Professionals.

Show: