The DBExplorer Utility

Sunbelt's DBExplorer is a graphical utility program that allows a user to manage SQLite databases. With the utility, a user can:

• Create a new database

 

• Export the database to an SQL text file or an XML format file

 

• Create, copy, rename, and delete tables

 

• Import or export data from tables

 

• Insert, edit, and delete columns within tables

 

• Add, edit, or remove table indexes

 

• Add, edit, or remove triggers

 

• Add, edit, or delete data within a table

 

• Execute SQL statements and view the result set

Graphical Layout

The DBExplorer presents information using a hierarchial tree structure on the left side of the screen and a tabbed dialog of categorized information on the right. Upon opening a database, the structure of tables, columns, indexes, triggers, and views are shown in the hierarchial tree.

The example below shows a database named "sample.db" and its internal structure of tables, columns, indexes, triggers, and views.

In the panel on the left is the hierarchial display of the structure. The right panel shows the tabbed dialog with pages for the database, tables, columns, indexes, views, triggers, data, and SQL. The bottom panel displays informational messages and shows commands executed by the DBExplorer. Each panel may be sized by selecting the splitter between the panels and moving in the desired direction.

Across the top, a menu provides access to many of the DBExplorer's functions. A toolbar beneath the menu allows quick selection of frequently used menu functions. Many menu functions also have a quick select key specification. The quick select keys are shown to the right of the item within the menu.

Also available are shortcut menus. These menus are shown when the right mouse is clicked on a tree or panel item.

And finally, program help is available either by clicking the F1 key or by using one of the designated Help buttons on the various input forms.