The Database Menu

Frequently used database tasks are grouped in this menu.

Database->Create Table... (Ctrl+T)

The same as in the Context menu, except that you can choose any database in the current schema in which to create your table, intead of only the selected one. See full Create Table documentation

Database->Create View... (Ctrl+G)

The same as in the Context menu, except that you can choose any database in the current schema in which to create your view, intead of only the selected one. See full Create View documentation.

Database->Build Query... (Ctrl+R)

Raise a dialog to build and execute a simple query on any table or view. This is the same dialog as in the Context menu, but you can choose the table or view and the schema if one or more additional databases are attached. See full Query Builder documentation .

Database->SQL Editor (Ctrl+E)

Toggle On/Off the SQL Editor pane in the main window.

Database->Schema Browser (Ctrl+B)

Toggle On/Off the Schema Browser pane in the main window.

Database->Data Viewer (Ctrl+D)

Toggle On/Off the Data Viewer pane in the main window.

Database-> Export Schema...

Generate an SQL script containing a transaction which creates all of the tables, views, indexes, and triggers in this database, but no data. It will first raise a dialog asking you where to save the output.

Database->Dump Database...

Generate an SQL script containing a transaction which creates all of the tables, views, indexes, and triggers in this database, and inserts the data into all of the tables. It will first raise a dialog asking you where to save the output.

Database->Import Table Data...

Import data into specified table. The import dialog with guided steps is shown.