Documentation Home
MySQL Workbench Manual
Related Documentation Download this Manual
PDF (US Ltr) - 17.0Mb
PDF (A4) - 17.0Mb

MySQL Workbench Manual  /  ...  /  The Physical Schemas Panel The Physical Schemas Panel

The Physical Schemas panel of the MySQL Model page shows the active schemas and the objects that they contain. Expand and contract the Physical Schemas panel by clicking the arrow for the panel.

MySQL Workbench provides the details of each physical schema in a separate tab. A new model includes an initial schema named mydb by default. You can start working with this schema (add or edit table, view, and group objects) or create additional schemas in the model. When you save a new model, MySQL Workbench creates an icon in the models view of the home screen tab. Each model icon shows the model name, schema name, and the location of the model file (models use the .mwb extension). A model with multiple schemas shows the name of the last schema that you added to the model.

To add a new schema, click + on the Physical Schemas panel. To remove a schema, select its tab and click -. The other three buttons on the panel control how database object information is displayed, specifically:

  • The left button displays database objects as large icons.

  • The middle button displays small icons in multiple rows.

  • The right button displays small icons in a single list. The Schema Objects Panel

The Physical Schemas panel has the following sections:

  • Tables

  • Views

  • Routines

  • Routine Groups

Each section contains the specified database objects and an icon used for creating additional objects.

Any database objects added to an EER diagram canvas also show up in the Physical Schemas section. For information about adding objects to an EER diagram canvas, see Section 9.1.2, “EER Diagram Editor”.