Eine Einführung in
|
| SQLite | ||
| 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 SQLite | ||
| none | ||
| DB2 | ||
| 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 DB2 | ||
| none | ||
| MS Access | ||
| 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 MS Access | ||
| none | ||
| PostgreSQL | ||
| 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 PostgreSQL | ||
| none | ||
| Oracle | ||
| 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 Oracle | ||
We can examine this constraint to find the table that has it...
SELECT constraint_name, table_name, status
FROM user_constraints
WHERE r_constraint_name IN (
SELECT constraint_name
FROM user_constraints
WHERE table_name ='T_DEPT') | ||
| MS SQL Server | ||
| 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 MS SQL Server | ||
| none | ||
| 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. | ||
| Sybase | ||
| 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 Sybase | ||
| none | ||
| Mimer SQL | ||
| 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 Mimer SQL | ||
| none | ||