Copy Code Trigger Definition 

                
                CREATE trigger TR_TEAMFUNDRAISINGTEAM_DELETE_BBNCTEAMFUNDRAISINGTEAMIDMAP on dbo.TEAMFUNDRAISINGTEAM after delete not for replication
                as begin
                    delete from dbo.BBNCTEAMFUNDRAISINGTEAMIDMAP
                        where TEAMFUNDRAISINGTEAMID in (select ID from deleted)
                end