Copy Code Trigger Definition 

        
        create trigger TR_TEAMFUNDRAISINGTEAM_DELETE_FAFGROUPDIRECTHIERARCHY on dbo.TEAMFUNDRAISINGTEAM after delete not for replication
        as
            delete from dbo.FAFGROUPDIRECTHIERARCHY  
            where GROUPID IN (select ID from deleted) or CHILDGROUPID in (select ID from deleted)