MySQL Workbench Manual  /  ...  /  Schema and Table Inspector

8.2.3 Schema and Table Inspector

The Schema and Table Inspector includes the ability to analyze and repair tables, and also view table metrics.

Schema Inspector

Use the Schema Inspector to browse general information from schema objects (shown in the figure that follows). It allows you to perform maintenance tasks on tables such as ANALYZE, OPTIMIZE, CHECK, and CHECKSUM TABLE. To access the inspector, right-click a schema and select the Schema Inspector.

Figure 8.27 Schema Inspector

The figure content is described in the surrounding text.

Each tab lists topic-oriented information, such as "Tables", "Indexes", and "Triggers". From the Tables tab, click Inspect Table to open the Table Inspector, or Maintenance to open the table maintenance tools (shown in the figure that follows).

Figure 8.28 Schema Inspector: Table Maintenance

The figure content is described in the surrounding text.

Table Inspector

You can use the Table Inspector to view table information, which is similar to the Schema Inspector. The Table Inspector includes an easy-to-use interface for analyzing and creating indexes for your tables.

To open, right-click a table in the object browser of the Navigator pane and choose Table Inspector from the context menu as demonstrated in the following figure.

Figure 8.29 Open the Table Inspector

The figure content is described in the surrounding text.

The Table Inspector shows information related to the table. The next figure shows an example using the sakila.actor table.

Figure 8.30 Table Inspector: Info Tab

The figure content is described in the surrounding text.


User Comments
Sign Up Login You must be logged in to post a comment.