Delete

· You cant delete a primary key row who has an reference with another table value .

For example.

Delete from department where department_id=10 (Provided there are employees working in department 10)

Will return Integrity constraint violated error.

However

Following statement will easily get executed

Delete from department where department_id=10 (Provided there are no employees working in department 10)

· There is no Delete * from