Applying views to tables in a physical data model with a wizard

With a wizard, you can create new views for multiple tables 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 that contain many tables.

Before you begin

You must create a physical data model in a data design project.

Procedure

To apply views to tables in a physical data model by using a wizard:

  1. Right-click a database, schema, or table object in a physical data model from the Data Project Explorer, and select Apply View. A wizard opens.
  2. Complete the wizard steps. Select the tables to which views should be applied and select a schema in which to create the view. You can also specify a naming convention for the new views.
  3. Click Finish.

Results

The new views are created and displayed in the Data Project Explorer.


Feedback