Views (PDM)

A view is an alternative way of looking at the data in one or more tables. It is made up of a subset of columns from one or more tables.

You define a SQL query for each view.

• Creating a View
  You can create a view in any of the following ways:
• View Properties
  You can modify an object's properties from its property sheet. To open a view property sheet, double-click its diagram symbol or its Browser entry in the Views folder. The following sections detail the property sheet tabs that contain the properties most commonly entered for views.
• Working with View Queries
  You can edit queries associated with a view from the SQL Query tab of the view property sheet.
• Creating a Query Table
  A query table is a table whose data proceeds from the result of a query. In PowerDesigner, you design a query table using a view with a specific type, depending on the DBMS.
• Using Extended Dependencies for Views
  You can create extended dependencies between a view and the tables it depends on. Such links help to make relationships between model objects clearer but are not interpreted and checked by PowerDesigner.
• Defining a Generation Order for Views
  You can use extended dependencies to define an order in the generation of views.