Online Documentation for All SQLManager.net Products
|
DB Explorer |
|
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 |
|
|
|
|
|
Displays the Register Database Dialog (Shift+Alt+R). |
|
|
Unregisters the selected database (Shift+Alt+U). |
|
|
Displays the Register Host Wizard for registering multiple databases on one host (Shift+Ctrl+R). |
|
|
Unregisters all the databases from the current host (Shift+Ctrl+U). |
|
|
Connects to the selected database (Shift+Ctrl+C). |
|
|
Disconnects from the current database (Shift+Ctrl+D). |
|
|
Refreshes the object tree (F5). |
|
|
|
|
|
Displays table subobjects in the tree: fields, indices, etc. |
|
|
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) |
|
|
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. |