Favorites

• Introduction
• Using Favorite Toolbar Entries
• Adding Items to the Favorites ToolBar
• Organizing Favorites

Introduction

Navigating the Database Objects Tree down to the object can be quite time consuming for Database Objects that you work with often. By adding these objects to the Favorites toolbar, you have one-click access to them instead.  In addition to Database Objects, you can also add Bookmark script files to the Favorites toolbar.

Figure: Favorites toolbar in the main window

Using Favorite Toolbar Entries

When you click on a Database Object in the Favorites toolbar, the Database Objects Tree is expanded down to the object. If you're not connected to the database the object belongs to, a connection is automatically established. Clicking on a Bookmark in the Favorites toolbar opens it in the current SQL Editor. You can also open a Database Object in a separate window or open a Bookmark in a new SQL Editor using the right-click menus for the entries in the Favorites toolbar.

Figure: Right-click menu for a database object favorite

Figure: Right-click menu for a Bookmark

Adding Items to the Favorites ToolBar

The easiest way to add an item to the Favorites toolbar is to select the item in the Databases tab tree or the Script tab tree, drag it with the mouse key depressed and drop it in the Favorites toolbar by releasing the mouse button. If you have created Favorite folders, you can also drop the item on a folder.

You can also use the Add to Favorite right-click menu operation for the Database Object or Bookmark. This opens a dialog where you can add the item, at the top level or in an existing or new Favorite folder.

Figure: Add as Favorite window

Organizing Favorites

Open the Favorites Editor by clicking the button to the left in the Favorites toolbar or select the corresponding operation from the Tools menu in the main window.

Figure: Favorites Editor window

Here you can add folders and drag and drop entries between them. A Favorite folder works as a drop-down menu in the Favorites toolbar. Double click a favorite to open the target script file in the SQL Commander or database object in the object view. To further configure the double click behavior for script files check check Tool Properties->Scripts.

Press ALT and double click a database object favorite to open the target object it in a separate window.

Note that the right-click menu works even for entries in a folder.

You can also delete and rename entries here. The right-click menu for an entry also contains entry-type dependent operations, such as executing a Bookmark and open a Database Object in a separate window.

---