Neoview SQL Reference Manual (R2.4 SP2)

Views

A view provides an alternate way of looking at data in one or more tables. A view is a named

specification of a result table, which is a set of rows selected or generated from one or more base

tables or other views. The specification is a SELECT statement that is executed whenever the

view is referenced.

A view is a logical table created with the CREATE VIEW statement and derived by projecting a

subset of columns, restricting a subset of rows, or both, from one or more base tables or other

views.

SQL Views

A view’s name must be unique among table and view names within the schema that contains it.

Single table views can be updatable. Multitable views are not updatable.

For information about SQL views, see “CREATE VIEW Statement” (page 101), “ALTER VIEW

Statement” (page 54), and “DROP VIEW Statement” (page 118).

Example of a View

You can define a view to show only part of the data in a table. For example, this EMPLIST view

is defined as part of the EMPLOYEE table:

JOBCODEDEPTNUMLAST_NAMEFIRST_NAMEEMPNUM

1009000GREENROGER1

1001000HOWARDJERRY23

3003000WALKERTIM75

. . .. . .. . .. . .. . .

In this sample view, the columns are EMPNUM, FIRST_NAME, LAST_NAME, DEPTNUM, and

JOBCODE. The SALARY column in the EMPLOYEE table is not part of the EMPLIST view.