ممکنه در این باره یه کم بیشتر توضیح بدی
The relational database management system (RDBMS) enforces referential integrity,
normally either by deleting the foreign key rows as well to maintain integrity, or by returning an error and not performing the delete. Which method is used would be defined by the definition of the referential integrity constraint.