A view table is a view of an existing table. A view table never actually exists physically but is created from the rows of the underlying base table(s).
Property |
Description (Link to SQL Reference Manual) |
---|---|
View Name |
The same rules as for table names apply: Table Name (table_name) |
Schema |
|
Replace Existing View |
If you choose these option, the view table replaces a previously existing view table. |
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 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. |
Property |
Description |
---|---|
View Column |
Column name in the view table |
Table Schema |
Schema |
Table Name |
Name of the base table |
Table Column |
Name of the column in the base table |
Data Type |
|
Dim |
Dimension Maximum number of characters |
Code |
|
Tenant Type |
Only in multi-tenant systems Tenant type |
Not Null |
If you select this option, the value for this column cannot be a NULL value. |
Default |
Default value |
SQL Reference Manual, CREATE VIEW Statement (create_view_statement)
SQL Tutorial, View Tables
Database Studio,