Home > Data Modeler Dialog Boxes > View Properties
This dialog box displays the properties of a view, which is part of Relational Models.
General
Name: Name of the view.
Query Builder: Click to display a query builder interface, in which you can create a view from the query by specifying tables and columns, as well as other information. In the query builder:
You can drag and drop tables into the main area; click to select columns to be included; view, copy, and paste the query SQL; and edit the SQL, or make it read-only reflecting the main diagram.
Filter Metadata Objects by Diagram makes it easier to find objects when there are very many metadata objects.
Show Structure Tree shows a structure view of the query.
Show Criteria List lets you specify criteria for the SELECT statement. Your specifications can affect the WHERE clause, and any GROUP BY, HAVING and ORDER BY clauses.
Based on Structured Type: For a view based on a structured type, the name of the type.
OID Columns: Object identifier (OID) column name or names.
Allow Type Substitution: If applicable, controls whether a substitutional structured type generation in the DDL is allowed
Reference Elements
Displays any currently defined columns in the view.
SQL for View on Structured Type
For a view on a structured type, the SQL statement for the view.
Comments in RDBMS
Comment text to be included in database objects that are generated based on this modeling object.
Scripts
Before Drop/Rename: Statements to execute before the view is dropped or renamed.
Before Create: Statements to execute before the view is created.
After Create: Statements to execute after the view is created.
End of Script: Statements to execute after all other statements in the script have been executed.
Include into DDL Script: Enables user-defined scripts to be included in the generated DDL at defined events, such as before drop or end of script.
Comments, Notes, Impact Analysis, Measurements, Change Requests, Responsible Parties, Documents, Summary