Online Documentation for SQL Manager for InterBase/Firebird

Creating/editing view

Use the Object tab of View Editor to create/edit a view and specify its definition.

View Editor provides two modes: Text editor and Visual editor. To switch between these editor modes, use the corresponding items available in the General group of the Navigation bar and toolbar.

When in the Text editor mode, you can use the editor area to specify the view definition as SQL statement using a template, hence it is enough to simply edit the template using the editor area to make appropriate changes, and compile the view.

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 query and Using the context menu.

When in the Visual editor mode, you are provided with a set of widgets allowing you to benefit from graphical user interface while editing the object properties.

Name

Enter a name for the new view, or modify the name of the view being edited.

The Fields list provides the following attributes of each field of the view:

Name

Field Type

Domain

Description

If necessary, you can also use the Field Description area to supply a description for each field.

The lower area allows you to specify the AS clause of the view definition. When editing the view, you can edit the definition using the editor area to make appropriate changes, and recompile the view.

Note: When you edit the query of the AS clause, all the changes you make are processed by the View Editor precompiler, and the list of fields is formed automatically.

To compile a view, you can use the Compile item available within the Navigation bar or toolbar.