Home > Data Modeler Dialog Boxes > View Properties (Logical Mo...
This dialog box displays the properties of a view in a Logical Model.
General
Name: Name of the view.
Query Builder: Click to display a query builder interface, in which you can create a view from the query by specifying tables and columns, as well as other information. In the query builder:
You can drag and drop tables into the main area; click to select columns to be included; view, copy, and paste the query SQL; and edit the SQL, or make it read-only reflecting the main diagram.
Filter Metadata Objects by Diagram makes it easier to find objects when there are very many metadata objects.
Show Structure Tree shows a structure view of the query.
Show Criteria List lets you specify criteria for the SELECT statement. Your specifications can affect the WHERE clause, and any GROUP BY, HAVING and ORDER BY clauses.
Based on Structured Type: For a view based on a structured type, the name of the type.
View Type: Type of view: entity view or named view.
Engineer To
Enables you to specify the relational models to which this view should be propagated in forward engineering operations.
Engineer: Controls whether the view is propagated to the specified Relational Design (model) during forward engineering operations.
Comments in RDBMS
Comment text to be included in database objects that are generated based on this modeling object.
Comments, Notes, Impact Analysis, Measurements, Change Requests, Responsible Parties, Documents, Dynamic Properties, Summary