MySQL Workbench
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 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”.