Model Database Views
A database View defines a subset of the database, aggregated into a dynamic 'virtual' Table.
Access Tools | Database Builder | Right-click on Views Package | Add new View
A View element is immediately added to the Package, with the name highlighted for change. Type an appropriate name.
To define the database View, double-click on it. The View: <view name> dialog displays.
|·||The Database field defaults to the DBMS for which you are defining the database|
|·||In the Notes field, type some notes on, or a description of, the View|
|·||In the View definition field, type the full view definition; the code editor provides Intelli-sense for basic SQL keywords and functions|
To delete a database View, right-click on the View name and click on the Delete <view name> option. A prompt displays to confirm deletion of the View and its contents; click on the Yes button.
|·||If you create a database View element external to the Database Builder, in any part of the model other than the Views Package, that View element is automatically reassigned to the Views Package|