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 tab 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.


Internal schemas, such as performance_schema, information_schema, and mysql, are hidden by default. Select the Show Metadata and Internal Schemas preference (see Preferences: SQL Editor: Main) to list them in the object browser. Schemas beginning with the period character (.) are also controlled by this setting.

Figure 8.20 SQL Editor - Navigator Schemas Tab

Content is described in the surrounding text.

Schema context menu.  Right-click any schema object to show the context menu. Right-clicking on a schema provides similar options to the table context menu (see Table, view, and column context menus), but the operations refer to the schema. For example, the Table Maintenance item in the table context menu opens the Schema Inspector, which is a schema context menu item, but it is populated with information about the selected table.

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.

Table, view, and column context menus.  The schema navigator also features a context menu, which can be displayed by right-clicking a table, view, or column object. For example, right-clicking a table displays the following menu items: