The View object describes a view table. A view table describes the logical view of one or more tables that may themselves be view tables. A view table can be handled like any other table and, as such, has the same relationships to other objects as described for Table. You can create, view, alter, and delete a view definition. The view definition determines the relationship between View and Table and between Column and Column.
Relationship between a view and other objects:
1. View Contains Column
2. View Uses Snapshot
3. View Uses Synonym
4. View Uses Table
5. View Uses View
6. Easycommand Uses View
7. Easyform Uses View
8. Module Uses View
9. Qpcommand Uses View
10. Qpquery Uses View
11. Querycommand Uses View
12. Snapshot Uses View
13. Synonym Refers to View
14. User Uses View
1. A view table comprises one or more columns; a view column is uniquely assigned to a view table (1-N).
2. A view table can refer to one or more snapshots; a snapshot can be used by a view table (N[0]-M[0]).
3. A view table can refer to a number of synonyms; a synonym can be used by a view table (N[0]-M[0]).
4. A view table refers to one or more tables; a table can be used by a view table (N[0]-M).
5. A view table can refer to one or more view tables; a view table can be used by a view table (N[0]-M[0]).
6. An EASY command can use a number of view tables; a view table can be used by an EASY command (N[0]-M[0]).
7. An EASY form can be used by a number of view tables; a view table can be used in an EASY form (N[0]-M[0]).
8. A module can use a number of view tables; a view table can be used by a number of modules (N[0]-M[0]).
9. A QueryPlus command can use a number of view tables; a view table can be used by a number of QueryPlus commands (N[0]-M[0]).
10. A QueryPlus query can use a number of view tables; a view table can be used by a number of QueryPlus queries (N[0]-M[0]).
11. A QUERY command can use a number of view tables; a view table can be used by a number of QUERY commands (N[0]-M[0]).
12. A snapshot can refer to a number of view tables; a view table can be used by a number of snapshots (N[0]-M[0]).
13. A synonym can refer to a view table; a number of synonym definitions can exist for a view table (N[0]-1[0]).
14. A user can use a number of view tables; a view table is used by one or more users (N-M[0]).
See also:
Managing Access Privileges for Views