If a trigger is being written to enforce referential integrity actions,you cannot use an INSTEAD OF trigger.

Question

Quizplus · Accepted Answer

INSTEAD OF triggers can be used to enforce referential integrity by manually coding the logic to check for foreign key constraints and perform the necessary actions, making them a flexible tool for handling complex integrity requirements in scenarios where the built-in constraints might not suffice.

If a Trigger Is Being Written to Enforce Referential Integrity