Was this helpful?
DEFINE VIEW--Define Virtual Tables
Valid in: QUEL, EQUEL
Defines a virtual table.
This statement has the following format:
[##] define view view_name (target_list) [where qual]
The define view statement defines a view. A view is a virtual table: the view definition is stored, but define view does not create any new base tables. The syntax of the define view statement is similar to the retrieve statement. When the view is used to form queries, the DBMS Server interprets the query to retrieve data from the base tables that define the view.
Last modified date: 06/08/2023