Chapter 9 Working with Data Models
To set display preferences for views, select Tools→Display Preferences, and select the View sub-category in the left-hand Category pane.
| Preference | Description |
|---|---|
| Columns | Displays the columns in the view. When selected, you can choose between displaying all the columns, or to limit them to a given number. |
| Tables | Displays the tables in the view. |
| Indexes | For those DBMS that support query tables, displays the indexes in the views of type materialized view, summary table or snapshot. |
| Owner | Displays the names of view owners. |
| Stereotype | Displays the stereotypes of views. |
| Comment | Displays the comments associated with views. When selected, all other check boxes except for Stereotype are deselected. |
The following display preferences are available for view columns:
| Preference | Description |
|---|---|
| Name | Displays the view column names. |
| Expression | Displays the SQL expressions for view columns. |
| Data types | Displays the data type for view columns. |
| Index indicator | For those DBMS that support query tables, displays the indicator next to indexed columns. |
| Copyright (C) 2008. Sybase Inc. All rights reserved. |
| |