Show TOC

Creating View TablesLocate this document in the navigation structure


A view table is a view of an existing table. A view table never actually exists physically but rather is formed by the database system from the rows of the underlying table(s).

  • You are logged on to the database as a database user.

  • You have the SELECT privilege for all columns that you want to include in the view table.

    More information: SQL Reference Manual, Privilege Specification (priv_spec)

  • The database is in the ONLINE operational state.

  1. In the explorer tree, select the table that you want to use as the basis for the view table.

  2. In the context menu of the table, choose Start of the navigation path New Next navigation step View. End of the navigation path

  3. Enter the following data:

    Table 1: View: Properties


    Description (Link to SQL Reference Manual)

    View Name

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


    Schema Name (schema_name)

    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.

  4. To copy the columns that you want to display in the result view, drag them to the Query Columns area.

  5. Optional: In the Query Columns area, enter search conditions and other attributes of the result view.

    Table 2: Visual Query: Search Conditions and Attributes of the Result View




    Synonym for the column name in the result view


    Column is displayed in the result view.


    Listing of column values in the result view


    Search condition

    • If you specify a search condition for a column with the data type CHAR, VARCHAR, DATE, or TIME, you must put the relational expression between single quotation marks.

    • You can enter more than one search condition using AND or OR links. If you want to use one column several times to formulate search conditions, but only want to display it once, you can hide it in the result view.

    • To enter several search conditions with AND links, enter them in the same row.

    • To formulate several search conditions with OR links, enter each of these conditions in a new row.

    More information: SQL Reference Manual,

  6. In the context menu of the editor window, choose Execute.

    You become the owner of the view table. For information about the privileges that the owner of the table view has, see SQL Reference Manual under INSERT-/UPDATE/DELETE Privilege for Owners of the View Table.

More Information