Views

A view is a virtual table that is formed by a query expression against one or more tables. Views allow you to set up additional levels of table security, hide data complexity and present data from another perspective. The following options are supported with view definitions:

• Support projections (selecting only some of the columns of a table)
• Creating columns which are derivations of values of columns from the base tables
• Restricting the records of the base tables
• Join queries
• Views on views