The view editor lets you edit view table definitions.
Property |
Description (Link to SQL Reference Manual) |
---|---|
View Name |
The same rules as for table names apply:Table Name (table_name) |
Schema |
|
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. |
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). |
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 |
SQL statement that generates the view table.
SQL Reference Manual, CREATE VIEW Statement (create_view_statement)
SQL Tutorial, View Tables