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 corresponding object is opened in an Object View tab. If you're not connected to the database the database object belongs to, a connection is automatically established. Clicking on a Bookmark in the Favorites toolbar opens it in an SQL Commander tab.

You can also easily find the corresponding object in the Databases tab or Scripts tab tree using the Select Target Object right-click menu item.

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

Use the Favorites tab in the navigation area to organize your favorites.

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.

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.

To sort the favorites, select Sort from the right-click menu for any favorite. The sorting critera can be defined in the dialog that pops up.

Figure: Sort Favorites dialog

---