Online Documentation for All SQLManager.net Products

DB Explorer
Top  Previous  Next


Database Explorer (or DB Explorer) is the basic navigation window for working with databases and database objects. Its treelike structure allows you to find and manage the needed tables in different databases quickly and easily. To view or hide this window use the View | DB Explorer menu item or press F11.

DB Explorer is divided into the following areas:

Databases
This is the main DB Explorer tab. It displays the tree of registered databases and their tables.

Project
This tab allows you to create your own projects and work only with the selected objects and queries.

Windows
This tab displays the list of all the DBISAM Manager active windows.

Recent
This tab displays the list of objects recently opened.

The SQL Assistant area gives you short information for each database or database objects, e.g. object description or list of its subobjects.

The buttons on the DB Explorer toolbar allow you to perform the following operations over databases and DB Explorer tree. Note that this toolbar is available only if Floating Windows Environment is implemented (see Environment Options | Windows).

Button
Action


regdb Register Database
Displays the Register Database Dialog (Shift+Alt+R).
unregdb Unregister Database
Unregisters the selected database (Shift+Alt+U).
reghost Register Host
Displays the Register Host Wizard for registering multiple databases on one host (Shift+Ctrl+R).
unreghost Unregister Host
Unregisters all the databases from the current host (Shift+Ctrl+U).
connect Connect to Database
Connects to the selected database (Shift+Ctrl+C).
disconnect Disconnect from Database
Disconnects from the current database (Shift+Ctrl+D).
refresh Refresh
Refreshes the object tree (F5).
view_mode View Mode
   subobjects Show Table Subobjects
Displays table subobjects in the tree: fields, indices, etc.
   page_mode DB Explorer Page Mode
Switches the DB Explorer view mode: if the button is dropped, Projects page is always displayed at the right side of the window. This allows you to Drag&Drop objects from one area to another. (Ctrl+P)
   servers Show Hosts
Displays host names in the database tree.
   Tables' Details

      Show Fields
Displays the list of table fields in the SQL Assistant.
      Show Indices
Displays the list of table indices in the SQL Assistant.
      Table Status
Displays table properties in the SQL Assistant: table type, row format, etc.