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
Prerequisites: 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.
To rename and refactor
a schema in a physical data model:
- In the Data Project Explorer, expand a physical data model
and right-click a schema.
- Select .
- 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.
- 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.