Databases Reference
In-Depth Information
Choosing one of the values (by clicking either a key value or a description) closes this
window and brings the value back to the
software_id
column.
Referential Integrity Checks
We discussed the
Operations
sub-page and its
Table maintenance
section in
Chapter 10. If we have defined an internal relation for the
authors
table (a non-InnoDB
table), a new choice appears for the
topics
table:
Check referential integrity
:
A link (here,
author_id -> authors.author_id
) appears for each defined relation, and
clicking it starts a verification. For each row, the presence of the corresponding key in
the foreign table is verified, and any errors are reported. If the resulting page reports
zero rows, this is good news!
Search WWH ::
Custom Search