Online Documentation for SQL Manager for DB2

Searching within the tree


SQL Manager for DB2 provides an ability to search for items within the DB Explorer tree. Searching for items may be useful if you have a lot of database objects, and it may be sometimes hard to find the one you need.

 

There are two search facilities implemented in SQL Manager for your convenience. You can search for objects within the DB Explorer tree in either of the following ways:

 

  • using the Find Object dialog

To call the Find Object dialog, right-click the Database alias, any database object group nodes or objects in the DB Explorer tree and select the Find Object... context menu item, or use the Ctrl+F shortcut.

 

DB Explorer - Find Object

 

 

Available search options are similar to those provided by the Find Text dialog. For detailed description of the search options refer to the Find Text dialog page.

 

Note: You can specify whether the search will be performed within the entire tree or within the currently selected node only: toggle search mode using the btnDBExplorer_SearchByCategory Search by categories button on the Search Panel, or use the corresponding option available in the Tools | DB Explorer section of the Environment Options dialog.

  • using the Search Panel

Type in the first letters in the edit-box, and the corresponding object will be highlighted in the tree, as displayed in the picture below. The btnDBExplorer_SearchPrev btnDBExplorer_SearchNext buttons allow you to define the search direction. The btnDBExplorer_SearchByCategory button toggles searching by category.

 

DB Explorer - Search Panel

 

 

By default, the Search Panel is activated in the upper area of DB Explorer. To disable the panel, right-click within the panel and deselect the checkbox at the corresponding popup menu item.

 

DB Explorer - Search Panel - Activate

 

 

Hint: The Search Panel is dockable, i.e. you can drag it to any location within the DB Explorer form.

 

 


See also:

Find Text dialog