If you want to delete a customer from tblCustomer when referential integrity is turned on,and that customer has appointments in tblSchedule,then the appointments for the customer have to be deleted from the tblCustomer first.

Question

Quizplus · Accepted Answer

When referential integrity is turned on, the appointments for the customer would need to be deleted from tblSchedule first, not tblCustomer, to maintain the integrity of the database relationships.

If You Want to Delete a Customer from TblCustomer When