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.
View Builder: Click to display a view builder interface, in which you can create a view by specifying tables and columns, a 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.
Impact Analysis
Enables you to view and specify information to be used by Oracle Warehouse Builder for impact analysis.
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, Measurements, Change Requests, Responsible Parties, Documents, Summary