View properties

Chapter 3 Building Physical Diagrams

You can double-click any view symbol in a diagram to display its properties:

Property	Description
Name	The name of the item which should be clear and meaningful, and should convey the item's purpose to non-technical users
Code	The technical name of the item used for generating code or scripts, which may be abbreviated, and should not generally include spaces
Comment	Descriptive label for the view
Stereotype	Sub-classification used to extend the semantics of an object without changing its structure; it can be predefined or user-defined
Owner	Name of view owner. You choose an owner from a list of users. A view can only have one owner at a time. This is normally the view creator
Usage	Defines the use of the view: Query only defines a view for consultation only, view cannot update tables; Updatable defines a view for consultation and update, view can update tables; and With Check options implements controls on view insertions
Dimensional type	Indicates the multidimensional type of the view, that is Dimension or Fact
Type	For those DBMS that support it, allows you to define the type of a view. You can select materialized query table, materialized view, summary table, or XML
Generate	Includes view generation as part of database generation script
User-defined	When selected, makes sure the view query is not parsed by PowerDesigner internal parser. This protects the view query from any update using model objects and keeps its syntax as defined by user. Otherwise, the view query is parsed and modified according to model values

For more information on materialized views, materialized query tables, and summary tables, see section Defining query tables in a physical diagram.

For more information on XML views, see section Creating an XML table or view.

A view also includes the following properties:

Property	Description
Columns	Columns of the view
Triggers	Triggers of the view
SQL Query	SELECT statements defining the view
Preview	SQL preview of view definition