Online Documentation for SQL Manager for DB2

Managing Favorite objects


Use the Favorite objects node for each database to work with the selected objects of this database only. You can place any object link from the database tree here.

 

You can also create a separate tab for your favorite object. See Using tabs for database navigation section for details.

 

DB Explorer - Managing projects - NewTab

 

 

Creating project folders

In order to create a new folder:

  • create a folder (if necessary, you can create subfolders inside the favorite objects folder) by right-clicking the Favorite Objects node and selecting the New Sub Folder... context menu item;

 

DB Explorer - Managing projects - New Subfolder

 

 

  • enter the folder name within the New Folder dialog.

 

 

Adding objects

In order to add a new object to the favorite objects folder:

  • extent the Favorite Objects node in DB Explorer;
  • drag an object (or multiple objects) from the database tree to the favorite objects folder

or

  • right-click the favorite objects folder and select the Add Object... context menu item, or use the Ins key;
  • use the Select Object dialog to specify objects to be added to the favorite objects folder.

 

DB Explorer - Managing projects - Adding objects

 

 

Removing objects from the favorite objects

In order to remove an object from the favorite objects:

  • right-click the object and select the Remove <object_name> from Folder context menu item, or use the Shift+Ctrl+Del shortcut;
  • confirm removing in the dialog window.

 

Note: This operation does not drop the object from the database, but only removes its alias from the favorite objects tree.