| MySQL | ||
| If a foreign key is set up between two tables it may be that you cannot delete a record. In this case the table t_staff references the table t_dept - you cannot delete the department 'co' if a member of staff belongs to that department. | ||
| Specific to MySQL | ||
| Referential integrity will be respected if the tables were created with type INNODB. This will not always be the case. | ||