EMS logo

Products Navigation

SQL Manager for SQL Server

Our Partnership Status

Microsoft Certified Partner
Oracle Certified Partner
Embarcadero Technology Partner

EMS SQL Manager for SQL Server

On-line Documentation

Database navigation

After you have registered the required database(s), the corresponding alias(es) appear in the DB Explorer tree on the left. If the Show Hosts option is checked on the Environment Options | DB Explorer page, the host nodes are also displayed in the tree (alternatively, you can use the Show Hosts item of the Database context menu, or the drop-down menu of the btnViewMode View Mode toolbar button for the same purpose). If necessary, you can also specify that empty schemas should be hidden in the tree: use the corresponding option available on the DB Explorer page of the Environment Options dialog.


Getting started - Database navigation



DB Explorer displays all registered databases. Connected/disconnected databases can be easily distinguished in the tree: aliases of disconnected databases are grayed out.


Getting started - Database navigation - Disconnected DB



To connect to a database, simply double-click its alias (or select the database alias in DB Explorer and press Enter). If the connection is successful, the database node expands into a tree of objects. To select the types of objects to be expanded upon successful database connection, you can use the Expand on connection group of the Environment Options | DB Explorer page.


Now you can navigate within the database objects. Use SQL Assistant to get extended information about the currently selected object.



For your convenience objects having different status (e.g. enabled/disabled) are displayed with different icons in Database Explorer.



See also:

Selecting style and language

First time started

Using Desktop Panel

Working with database objects

Using context menus

Working with windows