The View Editor is provided for altering SQL views. To open the View Editor, simply double-click a view on the diagram or select the Properties item from the context menu.
The View Editor contains several tabs, each of which will be described below.
General
This tab allows you to set the name of the view and write comments for it. There are the following fields on the tab:
View Name
Sets the name of the view. To check your diagram for the uniqueness of names use the Check Diagram tool.
View Schema
The name of the schema where the view will be placed.
Owner
A role which will be owner of the object, or a role which will execute CREATE script in case of empty input field.
Temporary
If specified, the view is created as a temporary view. Temporary views are automatically dropped at the end of the current session. Existing permanent relations with the same name are not visible to the current session while the temporary view exists, unless they are referenced with schema-qualified names.
If any of the tables referenced by the view are temporary, the view is created as a temporary view (whether TEMPORARY is specified or not).
Security Barrier
This option should be enabled when a view is intended to provide row-level security.
Comments
A native comment for the view.
Generate
Set this option off to exclude the view from the default selection in the Database Generation and Database Modification tools.
SQL Query
This tab allows to set the SELECT statement that provides the definition of the view. The optional column list can be given to define explicit names for the view columns.
A view can be created from many kinds of SELECT statements. For example, the SELECT can refer to a single table, a join of multiple tables, or a UNION. The SELECT need not even refer to any tables.
An example of SELECT statement, which could be used here:
SELECT product_id, product_name FROM Products
Rules
Rules Editor allows you to modify view rules. See Rules Editor for tables desciption for details.
Script
This tab allows you to set SQL statements, which will be executed before (use Begin tab) and after (use End tab) generation of the view.
Preview
The Preview tab displays the SQL statement, which will be executed during the database generation. This statement is made up according to the changes you have made using previous tabs. Note, that the text within the editor is read-only. The content of this tab updates only then your press Apply button.
Notes
The Note tab allows you to define a description and an annotation for the edited view. This properties will not affect the physical database, but they can be useful for your diagram development.
Format
These options allow you to set the view symbol line and fill color for displaying on the diagram, different from the default colors.
See also:
Creating a View