Databases

This page displays all the registered databases. If connection to the database is set, its object tree is built with branches Tables, and its icon and alias are displayed in bold.

If database contains tables, the name of the Tables branch is bold and the number of enclosed elements is displayed at the right.

The list of the enclosed elements for the selected branch is displayed in the SQL Assistant area. If certain database object is selected, some information about this object is displayed in the SQL Assistant area.

Double-clicking the object activates the proper editor window.

The popup menu of the Databases tab provides you with the following functions:

Menu Item	Action
New Table	Activates the Create Table Dialog (see Table Properties and Field Editor) for creating a new table.
Edit Table	Activates the Table Editor for editing the selected table.
Rename Table (tables only)	Allows you to change the name of the selected table.
Drop Table	Allows you to drop the selected table.
Duplicate Object	Allows you to create a new table with the same properties as those of the selected object.
Data Manipulation
Export Data	Activates the Export Data Dialog, which allows you to export the selected table to file.
Export Data As Insert Statements	Activates the Export Data As Insert Dialog, which allows you to export the selected table to the SQL script as INSERT statements.
Import Data	Activates the Import Data Wizard, which allows you to import data to the selected table from file.
Table Properties	Displays the properties of the selected table - table type, row format, min and max row number, etc.
Find Item	Searches for objects in the database tree.
Refresh	Refreshes the object tree (F5).
Connect to Database	Connects to the selected database (Shift+Ctrl+C).
Disconnect from Database	Disconnects from the current database (Shift+Ctrl+D).
Register Database	Displays the Register Database Dialog (Shift+Alt+R).
Unregister Database	Unregisters the selected database (Shift+Alt+U).
Database Registration Info	Activates the Database Registration window, which allows you to view and edit database registration parameters.
Sort by Aliases	Sorts hosts and databases by their aliases in alphabetical order.
Register Host	Displays the Register Host Wizard for registering multiple databases on one host (Shift+Ctrl+R).
Unregister Host	Unregisters all the databases from the current host (Shift+Ctrl+U).
View Toolbar	Show/hides the DB Explorer toolbar.
View SQL Assistant	Shows/hides the SQL Assistant area.
Hide Disconnected Databases	Hides/shows the disconnected databases in the database tree.