The Physical Schemata
panel of the
MySQL Model
page shows the active schemata and
the objects that they contain.
Expand and contract the Physical Schemata
section by double-clicking the arrow on the left of the
Physical Schemata
title bar. When the
Physical Schemata
section is expanded, all the
schemata that are currently loaded are displayed.
Each schema shows as a tab; a specific schema is selected by
clicking its tab. When MySQL Workbench is first opened a default
schema, mydb
is selected. You can start working
with this schema or you can load a new MySQL Workbench Models
(MWB) file.
There are a variety of ways to add schema to the Physical
Schemata
panel. You can open an MWB file, reverse
engineer a MySQL create script, or, if you are using a commercial
version of MySQL Workbench, you can reverse engineer a database by
connecting to a MySQL server.
You can also add a new schema by clicking the
Physical Schemata
panel. To remove a schema,
click its tab and use the button found to
the immediate left of the button. To the
left of these buttons are three buttons that control the way
database object icons are displayed. The left-most button displays
database objects as large icons, the next button to the right
displays small icons in multiple rows, and the last button
displays small icons in a single list.
The Physical Schemata
panel is divided up
into 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 Schemata
section. For
information about adding objects to an EER diagram canvas see
Section 16.6.6, “EER Diagram Editor”.