Copy Code Trigger Definition 

CREATE TRIGGER TR_PersonalPageData_CASCDE_DEL_1
ON dbo.PersonalPageData
INSTEAD OF DELETE
AS
BEGIN
    DELETE dbo.EventCalendar WHERE PersonalPageDataID in (SELECT [ID] FROM Deleted)
    DELETE dbo.NewsChannels WHERE PersonalPageDataID in (SELECT [ID] FROM Deleted)
    DELETE dbo.PersonalPageData WHERE [ID] in (SELECT [ID] FROM Deleted)
END