Please note : This help page is not for the latest version of Enterprise Architect. The latest help can be found here.
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.
Notes
| · | 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 |
Learn more
The material ("material" includes all pages, documents and on-line graphics) on this web site is protected by copyright law. (C) 1998-2015 Sparx Systems Pty Ltd.
