This section deals with viewing catalogs, schemata, tables and their properties, creating databases, and performing a number of operations on tables. Existing catalogs and schemata are listed in the lower left area of the sidebar.
If there are many schemata on your MySQL server, the field with
the magnifying glass icon may be handy for filtering the schemata
you are looking for. Typing in t
or
T
, for example, will set the filter to schemata
whose names begin with a t
. The filter works in
a case-insensitive fashion.
You may also filter schemata using the wild card
?
to stand in for any single character and
*
for zero to any number of characters. For
example the string *boo?*
will find schemata
with the names books, coursebooks
and
bookings
.
Select the database that you wish to view. Right click on any database and choose the Refresh Schemata List option to refresh the database list. Clicking on a database will cause the Schema Tables and Schema Indices tabs to be populated with the tables and indexes of the selected database.
To create a new database, right click on an existing database and choose the Create New Schema option.