ThePhysical Schemas panel of theMySQL Model page shows the active schemas and the objects that they contain. Expand and contract thePhysical 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 namedmydb 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 thePhysical 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.
ThePhysical 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 thePhysical Schemas section. For information about adding objects to an EER diagram canvas, seeSection 9.1.2, “EER Diagram Editor”.