Background documentationView Editor Locate this document in the navigation structure

 

The view editor lets you edit view table definitions.

View: Properties

Property

Description (Link to SQL Reference Manual)

View Name

The same rules as for table names apply:Table Name (table_name)

Schema

Schema Name (schema_name)

Check on Insert and Update

If this option is set, you cannot use INSERT or UPDATE statements on the view table to generate any rows that can afterwards no longer be selected via the view table. Resulting rows must therefore fulfill the view table's search condition.

The option is inherited. This means that, if you have defined a view table VIEWTABLE1 with this option and are using VIEWTABLE1 in the FROM condition of a modifiable view table VIEWTABLE2, then only rows that can be selected using VIEWTABLE1 may be added or modified with VIEWTABLE2.

Replace Existing View

If you choose these option, the view table replaces a previously existing view table.

Indexes: Display Criteria

Option

Description

None

All indexes from the selected schema are displayed.

Only Bad Indexes

Only damaged indexes are displayed.

Only Disabled Indexes

Only disabled indexes are displayed.

Only Unused Indexes

Only unused indexes are displayed (INDEXUSED=0).

Optimizer Statistics

Property

Description

Columns and Indexes

Columns and indexes

Distinct Values

Estimated number of lines in the table

Page Count

Estimated table size (in pages)

This size affects which search strategy is selected by the system.

More information: SQL Optimizer, Search Strategies

Last Statistics Update

Time of the last statistics update

Create Statement

SQL statement that generates the view table.

More Information

SQL Reference Manual, CREATE VIEW Statement (create_view_statement)

SQL Tutorial, View Tables