Eine Einführung in

SQL

Cannot DELETE because of reference.

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.
Execute set up code


Specific to MS SQL Server
none