Databases Reference
In-Depth Information
Let's click at the appropriate place to delete this relation. We get a confirmation panel
on which we click Delete :
We can then proceed to recreate it. For this, we start by clicking the Create relation
icon. The cursor then takes the form of a short message saying Select referenced key .
In our case, the referenced key is the id column of the author table; thus we bring
the cursor on this column and click. A validation is done, ensuring that we chose a
primary or unique key.
Next, the cursor having changed to Select foreign key , we bring it to the author_id
column of the book table and click again. We then confirm the relation creation.
Currently, the interface does not permit to create compound keys (having more than
one column).
InnoDB Relations
To delete or define a relation between InnoDB tables, the procedure is the same as for
internal relations, except that at creation time, a different confirmation panel appears,
enabling us to specify ON DELETE and ON UPDATE actions.
 
Search WWH ::




Custom Search