SQL$HELP72.HLB  —  CREATE  VIEW
    Creates a view definition. A view is a logical structure that
    refers to rows stored in other tables. Data in a view is not
    physically stored in the database. You can include in a view
    definition combinations of rows and columns from other tables and
    view definitions in the schema. You define a view by specifying a
    select expression, that:

    o  Names the criteria for selecting the tables, rows, and columns
       for the view

    o  Specifies a set of columns from those tables

    When the CREATE VIEW statement executes, SQL adds the view
    definition to the physical database. If you declared the schema
    with the PATHNAME argument, the definition is also stored in the
    repository.
Additional Information: explode extract
Environment Format Arguments Examples
Close Help