Physical Modeling › Views › View Editor

Previous Topic: Views in the Model Explorer

Next Topic: Add a View

View Editor

Use the following options and tabs in the View Editor to add a new view or modify the properties of an existing view. Available options and tabs will vary based upon your target DBMS and the model properties you select in the Model Editor.

property editor PREVIOUS icon Previous

Positions the editor on the previous view in the Navigation Grid.

property editor NEXT icon Next

Positions the editor on the next view in the Navigation Grid.

property editor SORT icon Sort

Sorts the views by alphabetic or reverse alphabetic order. You select the method you want using the drop-down menu that opens after you click the Sort button. Visual cues are provided for how the view list is currently sorted:

property editor SORT icon

Specifies that the view list is sorted in alphabetic order.

Property editor Reverse Alpha Sort Button

Specifies that the view list is sorted in reverse alphabetic order.

New icon in property editors to create a new object New

Creates a new view that becomes the current object in the editor.

property editor DELETE button Delete

Deletes the selected view.

property editor DB SYNC button DB Sync

Opens the DB Sync wizard so you can perform a database level compare of objects in the current model with matching objects in another model.

property editor HELP button Help

Opens online help for the editor.

enter filter text box in a property editor to filter object list

Lets you filter a very large list of tables in the Navigation Grid to quickly locate the table for which you need to view or define properties.

Name

Specifies the name of the view. You can change the name of the view in this field.

Schema

Specifies the schema to which the view belongs. Select from the drop-down list.

Generate

Generates SQL during forward engineering. Clear the check box if you do not want to generate SQL.

Common Table Expression

Specifies a common table expression for use with the fullselect.

Select Tab

Specify the tables or views to use to define the view column.

From Tab

Select the tables and views that you want to include in the view.

Clauses Tab

Enter text to define a WHERE clause.

Query Options Tab

Specify the options to execute the query.

User Defined SQL Tab

View and change a user-provided DDL statement.

SQL Tab

View the SQL code used during Forward Engineering.

Alias Tab

Specify an alias for the current view.

Permission Tab

Specify permissions for the current view.

Style Tab

Work with style sheets, which are used to format the font and other graphical themes used in the display of the view.

Icon Tab

Specify the icon style to use for the view.

Comment Tab

Lets you enter any comments that you want to associate with the view.

UDP Tab

Lets you enter user-defined property values for a view.

Notes Tab

View table history information and view or edit user notes.

More information:

Add a View

Define View Columns

Change the Columns Referenced by a View

Reorder the Columns Referenced by a View

Define View Sources

Define SQL Code Generation Criteria for a View

Change the SQL Code for a View

Enter a View Comment

Enter View User-Defined Property Values

Specify an Alias for a View Source Table

Attach a Table or View to a Script