The Navigator contains options to manage the active MySQL connection, and also lists the schemas available to that connection.
The Navigator is separated into three main sections that default to their own tabs within the Navigator. A Management tab offers management actions for the selected MySQL connection, a Performance tab displays key statistics and MySQL instance status information, and the Schemas tab lists the available schemas.
Navigator Schemas Tab
The Schemata list shows available schemata on the currently connected server. These can be explored to show tables, views, and routines within the schema.
It is possible to set a schema as the default schema by
right-clicking the schema and selecting the menu item. This executes a
USE
statement so that subsequent statements without schema
qualifiers are executed against this schema. This setting
applies only to the query session. To set a default schema for
multiple MySQL Workbench sessions, you must set the default schema
for the stored connection. From the Home screen, right-click
on a MySQL connection, choose , and set the desired default schema
on the Default Schema box.
schema_name
The selected schema is displayed as bold
in the Schema navigator.
Double-clicking a table, view, or column name in the schemata explorer inserts the name into the SQL Query area. This reduces typing significantly when entering SQL statements containing references to several tables, views, or columns.
The Schema Navigator also features a context menu which can be displayed by right-clicking an object. For example, right-clicking a table displays the following menu items:
: Pulls up to 1000 rows of table data from the live server into a Results tabsheet, and enables editing. Data can be saved directly to the live server.
: Displays table information, similar to the
Schema Inspector. This also has a simpler and easier to use interface for analyzing and creating indexes for tables.: There are various submenus, each of which copies information to the clipboard:
Name (short): Copies the table name.
Name (long): Copies the qualified table name in the form
`schema`.`table`.Select All Statement: Copies a statement to select all columns in this form:
SELECT `table`.`column1`, `table`.`column2`, ... FROM `schema`.`table`;
Insert Statement: Copies an
INSERTstatement to insert all columns.Update Statement: Copies an
UPDATEstatement to update all columns.Delete Statement: Copies a
DELETEstatement in the formDELETE FROM `world`.`country` WHERE <{where_condition}>;.Create Statement: Copies a
CREATEstatement in the formDELETE FROM `world`.`country` WHERE <{where_condition}>;.Delete with References: Copies a
DELETEstatement, in the form of a transaction, that deletes all objects that reference the row (directly or indirectly).Use first to preview this operation.
Select with References: Copies a
SELECTstatement that selects all objects that reference the row (directly or indirectly).Use to generate a DELETE statement for this operation.
: Provides functionality similar to Copy to Clipboard. However, this item inserts the SQL code directly into the SQL Query panel, where it can be edited further as required.
: Launches a dialog to enable you to create a new table.
: Launches a dialog to enable you to create a new table, and to also apply predefined templates.
: Displays the table editor loaded with the details of the table.
: Opens a new tab for performing table maintenance operations. Operations include "Analyze Table", "Optimize Table", "Check Table", and "Checksum Table". Additional information about the table may also be viewed from this tab.
: Drops the table. All data in the table will be lost if this operation is carried out.
: Truncates the table.
: Opens a new tab for performing table searches. It performs a search on all columns, and offers additional options to limit the search.
: Refreshes all schemata in the explorer by resynchronizing with the server.
Right-clicking on a schema provides similar options to the table context menu described above, but the operations refer to the Schema. For example, the Table Maintenance in the table context menu selects the table in the Schema Inspector, which is a schema context menu option.
User Comments