Views (PDM)

A view is a subset of columns drawn from one or more tables defined by a SQL query, which may specify complex criteria for how the tables are joined.

• Creating a View
  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.
• View Properties
  To view or edit a view's properties, double-click its diagram symbol or Browser or list entry. The property sheet tabs and fields listed here are those available by default, before any customization of the interface by you or an administrator.
• View Queries
  You can edit queries associated with a view from the SQL Query tab of the view property sheet.
• Materialized Views
  A materialized view is a table containing the results of a query. PowerDesigner supports materialized views for the DB2, HP Neoview, Netezza, Oracle, and Sybase SQL Anywhere DBMS families.
• Showing View Dependencies using Traceability Links
  You can use traceability links to make the relationships between views and tables clearer. These links are not interpreted and checked by PowerDesigner.
• Defining a Generation Order for Views
  You can define the order of the generation of views by using traceability links with a type of DBCreateAfter. The view from which you start the traceability link is dependent on the view you link it to, and this influent view will be generated before the dependent view.