Database Views

A Database View represents the results of a pre-defined query. Unlike a Table, a View is dynamically derived from data in one or more Tables (or other Views). Enterprise Architect supports the definition of Views both with and without this statement:

"Create View {viewName} As" statement

The system will automatically add it dynamically (if missing) whenever DDL generation is performed. The advantage of not defining this statement is that when a view object is renamed the 'View Definition' property does not have to be manually updated.

You can create a Database View either:

Within the Database Builder or

By dragging the 'View' icon from the Data Modeling Toolbox onto a diagram

Right-click on the new View element and select 'SQL Object Properties'.

The 'SQL Object Editor' screen displays.

SQL Object Editor

The SQL Object Editor is a dialog that is shared by a number of SQL-based database objects (Views, Procedures and Functions) and that helps you to manage the various properties of the SQL-based object.

Field/Option/Button

Action

See also

Database

If it has already been set, the default database type displays.

If the default has not been set, or you want to change the database type for this View, click on the drop-down arrow and select the target DBMS to model.