Modifying the view display preferences

Chapter 3 Building Physical Diagrams

You can modify the display preferences for a view and for the columns of a view using the Tools→Display Preferences command.

Text display preference	When selected, what it displays
Columns	All columns in the view, an asterisk () for multiple column selection, or a defined number (limit) of columns depending on the selections listed below
*All columns	All columns in the view. Multiple column selection is represented by an asterisk (*)
*Limit	(x) Number of columns depending on defined value of x
Tables	Tables in the view
Indexes	For those DBMS that support query tables, indexes in the views of type materialized view, summary table or snapshot
Owner	Name of view owner
Stereotype	Stereotype of the view
Comment	Comment of the view. When selected, all other check boxes are deselected, except for Stereotype

Text display preference	When selected, what it displays
Name	View column name
Expression	SQL expression for each view column
Data types	Data type for each view column
Index indicator	For those DBMS that support query tables, indicator next to indexed columns

For more information on query tables, see section Defining query tables in a physical diagram.