With a wizard, you can create indexes with the same properties
as a template index in a physical data model. Use the wizard instead of the
Data Project Explorer, the Properties view, or a physical data model diagram
to save time when you work with large physical data models.
Before you begin
Prerequisite: You must create one index in a physical data
model to use as a template. You can create a new index by using one of the
following methods:
- In the Data Project Explorer, right-click a database object in a physical
data model, and click . From the sub menu, select an index.
- Drag and drop an existing index from a database connection in the Database
Explorer to the physical data model.
About this task
To create new indexes in a physical data model by
using a wizard
- Right-click an index object in a physical data model from the Data
Project Explorer, and select Apply Index. A
wizard opens.
- Complete the wizard steps.
- On the first page of the wizard, you can select a different index to use
as a template.
- On the second page of the wizard, you select the constraints to which
the selected index should be applied, and specify a naming convention for
the new indexes.
- Click Finish.
Results
The new indexes are created and displayed in the Data Project Explorer.