Renaming and refactoring schemas in physical data models

When you rename schemas in physical data models by using the refactoring feature in this product, you also can update view references automatically.

Before you begin

You must have a physical data model stored in a data design project.

About this task

In addition to this method, you can also rename schemas by highlighting a schema object in a physical data model and pressing F2, either from the Data Project Explorer or a data diagram. However, if you use the F2 method, view objects are not automatically updated. Therefore, the approach that is described in this topic is the preferred method for renaming schemas.

Procedure

To rename and refactor a schema in a physical data model:

  1. In the Data Project Explorer, expand a physical data model and right-click a schema.
  2. Select Refactor > Rename.
  3. In the window that opens, specify a new name for the schema, and specify whether views that reference this schema should also be updated with the new schema name.
  4. Click OK.

Results

The schema is renamed, and any views that reference the schema are also updated if you specified this option. The changes are visible in the Data Project Explorer and in data diagrams that contain these objects.

Feedback