MySQL Workbench

8.2.1 Object Browser and Editor Navigator

The Navigator area of the sidebar contains options to manage the active MySQL connection. It also lists the schemas on the server for that connection. To access the Navigator area, open an existing connection (or create a new connection) from the home screen. If the panel is not visible, click View, Panels, and then Show Sidebar.

Navigator Schemas Tab

The Schemas list shows available schema on the currently connected server. These items can be explored to show tables, views, and routines within the schema as the following figure shows.

Note

Internal schemas, such as "performance_schema", "information"schema", "sys", and "mysql", are hidden by default. Toggle the Show Metadata and Internal Schemas preference to list them in the object browser. Schemas beginning with a "." are also controlled by this setting.

Figure 8.20 SQL Editor - Navigator Schemas Tab

Content is described in the surrounding text.

It is possible to set a schema as the default schema by right-clicking the schema and selecting the Set As Default Schema menu item. This executes a USE schema_name 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 Edit Connection, and set the desired default schema on the Default Schema box.

Note

The selected schema is displayed as bold in the Schema navigator.

Double-clicking a table, view, or column name in the schema 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:

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.