View Properties (Relational Model)

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:

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

See Common Information in Dialog Boxes.