Online Documentation for SQL Manager for DB2

View info

The View info section of the Create View from Table dialog provides the definition of the view generated from the table.

Name

Specifies view name (if necessary, you can edit the one assigned by default).

The Fields list displays view fields as specified in the fields clause and the AS clause of the view definition.

The list provides the following attributes of each field:

Name

Type

To add/remove fields to/from the construction, check/uncheck flags available in the first column of the Fields list.

For your convenience the Select All, Deselect All and Invert Selection functions are implemented in the context menu of the fields list area.

The lower area represents the view definition as SQL statement. It is possible to edit the definition directly using the editor area to make appropriate changes.

For your convenience the syntax highlight, code completion and a number of other features for efficient SQL editing are implemented. For details see Working with SQL Editor area and Using the context menu.