Home > Data Modeler Dialog Boxes > View Properties (Relational...
This dialog box displays the properties of a view in 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.
Schema: Schema of the database user that owns the view. If not specified, the current schema is assumed.
Include Schema Name in Query: If a schema is specified, you can have objects in the view's query prefixed by that schema name.
Use Objects Only From: Name of the relational model from which to use objects specified in the view.
Allow Type Substitution: If applicable, controls whether a substitutional structured type generation in the DDL is allowed.
Generate in DDL: controls whether the view definition is included when DDL is generated.
Test Query: Displays a dialog box in which you can specify a database connection and test the view's query.
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, Dynamic Properties, Summary