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.
Creating a View from the Tools Menu
You can create a view from the Tools menu. This method allows you to automatically populate the view with columns from tables and other views
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
Extended dependencies are links between physical diagram objects. These links help to make object relationships clearer between model objects but are not interpreted and checked by PowerDesigner as they are meant to be used for documentation purposes only.