Databases Reference
In-Depth Information
This view is used to:
• Deine the relations of the current table with the other tables
• Choose the display column
Our goal here is to create a relation between the
book
table (which contains the author
ID) and the
author
table (which describes each author by an ID). We start on the
Table
view for the
book
table, go to
Structure
, and click on the
Relation view
link.
Defining internal relations
If the
book
table is in
MyISAM
format, we see the following screen (otherwise, the display
would be different, as explained in the
Defining foreign key relations
section later):
Search WWH ::
Custom Search