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