TR_CONSTITUENTACCOUNT_DELETE_BBNCCONSTITACCOUNTIDMAP

                CREATE trigger TR_CONSTITUENTACCOUNT_DELETE_BBNCCONSTITACCOUNTIDMAP on dbo.CONSTITUENTACCOUNT after delete not for replication
                as begin
                    delete from dbo.BBNCCONSTITACCOUNTIDMAP
                        where CONSTITUENTACCOUNTID in (select ID from deleted)
                end