Defining a Schema as a Favorite

You can define a Schema as a Favorite. The Schema can be a schema of any type of database object - tables, procedures, triggers etc. You can also define other database objects (Tablespaces, Users) as a Favorite.

When you define a Schema as a favorite, the list of objects is fetched from the database when you click on the Schema. As a result, it will always include the up-to-date list of objects. This is by contrast to normal "fixed" favorites, which are a specific list of objects. By defining Schemas as favorites you can combine both the best of both worlds between the Favorites and Objects displays.

To define a Schema as a Favorite:

• click on the Schema (or other database object) in the Object Tree
• click on Favorites > Add Schema to Favorites. If you are adding an object which doesn't have a schema (such as Tablespaces or Users), this menu option will have a name such as Add Tablespaces to Favorities.
• you will be shown the Add to Favorites window. Select the folder for the favorite then click on OK. Note: you will not be able to enter a description for the Favorite.