Database Explorer (or DB Explorer) is the basic window of SQL Manager for DB2 for navigation within databases and working with database objects. The tree-like structure of DB Explorer allows you to manage the databases, database objects and perform other everyday operations quickly and easily.
The following list contains the most frequently used features provided by Database Explorer.
- Managing database registration info
- Connecting to databases
- Performing basic operations upon database objects
- Selecting multiple objects
- Navigating database objects using multiple tabs
- Easy access to recently opened objects
- Managing favorite objects
- Searching within the tree
- Viewing extended information about database objects
- Configuring Database Explorer
- Managing Favorite queries
All objects are structured by their types and are available within the corresponding nodes of the tree. The number of objects of each type is displayed in brackets after the node name denoting the object type. To expand/collapse a node, you can double-click it or use the +/- icons. Alternatively, yu can use "Right"/"Left" buttons: when pressing "Left", first the subnodes of the current node are collapsed, after pressing again the parent node is focused and so on; when pressing "Right" the current node expands.
To view/hide the Database Explorer window, use the View | DB Explorer main menu item or press the F11 key.
Use the Ctrl+Shift+C shortcut to collapse current DB Explorer tree branch and switch to the parent node.
Note that you can change host and database aliases order by dragging them within the DB Explorer tree.