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. It allows you to perform maintenance tasks on tables such as ANALYZE, OPTIMIZE, CHECK, and CHECKSUM TABLE. To access the inspector, right-click on a schema and select the Schema Inspector

Figure 8.27 Schema Inspector

Schema Inspector

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:

Figure 8.28 Schema Inspector: Table Maintenance

Schema Inspector: Table Maintenance

Table Inspector

Table Inspector

View table information, similar to the Schema Inspector. This also has a simpler and easier to use interface for analyzing and creating indexes for your tables.

To open, right-click on a table in the object browser and choose Table Inspector from the context menu.

Figure 8.29 Open the Table Inspector

Open the Table Inspector

The Table Inspector shows information related to the table.

Figure 8.30 Table Inspector: Info Tab

Table Inspector: Info Tab

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