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.
Prerequisite: You must create a physical data model in a data design project.

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. You can also specify a naming convention for the new views.
  3. Click Finish.

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

Related information
Physical data models
Creating a data design project
Generating relational views from SQL statements

Feedback