Defining relations with the Designer

The Ajax-based Designer offers a visually-driven way of managing relations (both internal and foreign key-based), and defining the display column for each table. It can also act as:

  • A menu to access the structure of existing tables and to access the table creation page
  • A PDF schema manager, if we want a PDF schema encompassing all our tables

On the Designer workspace, we can work on the relations for all tables on the same panel. On the other hand, the Relation view shows the relations for only a single table at a time.

We access this feature from the Database view by clicking on the Designer menu tab.

Note

If this menu tab does not appear, it's because we are yet to install the phpMyAdmin configuration storage as ...

Get Mastering phpMyAdmin 3.4 for Effective MySQL Management now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.