TR_PersonalPageElements_CASCDE_DEL_1

Definition

Copy


CREATE TRIGGER TR_PersonalPageElements_CASCDE_DEL_1
ON dbo.PersonalPageElements
INSTEAD OF DELETE
AS
BEGIN
    DELETE dbo.PersonalPageData WHERE [ElementID] = (SELECT [ID] FROM Deleted)
    DELETE dbo.PersonalPageElements WHERE [ID] = (SELECT [ID] FROM Deleted)
END