CREATE TRIGGER trig_page_menu ON PAGE_MENU FOR DELETE
AS
DECLARE @PageMenuID INT
SELECT @PageMenuID = (SELECT MENU_ID FROM Deleted)
DELETE FROM PAGE_MENU WHERE PARENT_ID = @PageMenuID
;