View Table 
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 |
|
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. |
Replace Existing View |
If you choose these option, the view table replaces a previously existing view table. |
More Information
SQL Reference Manual, CREATE VIEW Statement (create_view_statement)
SQL Tutorial, View Tables
Database Studio,