New View Dialog

You use the New View dialog to create a view in a database.

You can open this dialog the following ways:

• From the context menu of a database’s Views folder or view node: New View

• On the main menu ribbon when a Database node, view node, or Views folder is selected in the Instance Explorer: Database, View, New View (see Database Tab)

For more information, see Create a View.

This page lists existing tables and views on their respective tabs with the following options:

Specifies whether system tables and views in the database should be included on the Tables and Views tabs. System object names begin with “$ingres”.ii_.

Lists the user-created tables in the database. If Include System Objects is selected, this tab also lists system tables in the database.

Lists the user-created views in the database. If Include System Objects is selected, this tab also lists system views in the database.

Specifies that the query text is copied to a query document instead of being executed. You may then edit the SQL before executing it (see Execute a Query).

This page lets you specify whether to include all columns or only specific columns from the tables and views selected on the Tables & Views page. If you choose to specify particular columns, you may change the name of the column in the view by entering the new name in the Column Alias field.

The output columns of the SELECT are matched in the order they appear, with the column names specified. The column names are used in the new table. For example, if your SELECT statement contains:

and you specify column aliases apple, banana, cherry, the new table will contain columns named apple, banana, cherry. If there are more columns in the result than you have provided, the remaining columns in the result will not be renamed but will retain the names from their source.

Note: Director validates the names of the columns to ensure they are valid database names (see Object Naming Rules). All other validation is left to the DBMS.

This page lets you qualify your query statement and see how it is formed. It contains the following areas and options:

Lets you qualify the SELECT statement with qualifiers such as WHERE

Prevents the execution of an insert or update to a view that creates a row that does not comply with the view definition (the qualification specified in the WHERE clause).

If the With Check Option is not specified, any row in the view can be updated, even if the update results in a row that is no longer a part of the view.

You cannot update or insert into a view that is defined on top of a view specified with the With Check Option if the resulting rows violate the qualification of the underlying view.

Displays the CREATE VIEW SQL statement that is being built, based on your selections on the previous pages

Attempts to create the view using the information entered on the dialog. If successful, the new view node is displayed in the Instance Explorer.