INSTEAD OF

Specifies that the trigger is executed instead of the triggering SQL statement, thus overriding the actions of the triggering statements

Exemplul cu INSTEAD OF merge deoarece stergerea se face in ordinea corecta: mai intai telefoanele (DELETE FROM Telefon ...) si apoi localitatea (DELETE FROM Localitate ...).