The Views tab lists all of the database objects that can be exposed through Gatsby and various aspects of how the objects are exposed in Gatsby Database Explorer can be changed.
|
Tables | Tables from the database. |
|
Queries | For Microsoft Access databases this icon indicates that the object is a row returning query. For other databases these are view objects. |
|
Procedures | For Microsoft Access databases this icon indicates that the object is an action query. For other databases these are stored procedures. |
If an object is hidden, the icon will be dimmed.
The properties for an object can be viewed and updated by first selecting the object and then clicking the "Properties..." button. Some properties can be updated directly from the Views tab.
| Show | Determines if the object is displayed at the top-level of the Relational Navigation View in Gatsby Database Explorer. By default all objects are shown. To hide an object, right-mouse click on the object and uncheck "Show". Note that you cannot hide query objects from Microsoft Access database using the Design Assistant. To hide these objects, open the database in Microsoft Access right-mouse click on the Query object and select properties. |
| Caption | Provides a user-friendly name for the object. This does not rename object in the database. To change the caption, click on the label. This will allow you to edit it. |
Attributes of a database object can be viewed by clicking the plus sign to the left of the object. To update the properties of an attribute, first select the attribute the click the "Properties..." button. The caption for the attribute can be edited directly in the Views tab by clicking on the label.
Each attribute has an icon associated with it. If the attribute serves as the key for the object then it will have a key on the icon. If the attribute serves as part of the row caption it will have a caption bubble on it. Other attributes will have a solid circle icon if the attribute is required, otherwise it will have a hollow circle icon.
The list of database objects can be filtered using the buttons at the top of the tab. Filtering only affects the objects that are listed in the View tab. It does not hide objects in Gatsby Database Explorer.