CREATE TRIGGER trig_fragment ON FRAGMENT FOR DELETE
AS
DECLARE @FragID INT
SELECT @FragID = (SELECT FRAGMENT_ID FROM Deleted)
DELETE FROM FRAGMENT_ID WHERE PARENT_ID = @FragID
;