TR_RELATIONSHIP_DELETE_BBNCRELATIONSHIPIDMAP

CREATE trigger TR_RELATIONSHIP_DELETE_BBNCRELATIONSHIPIDMAP on dbo.RELATIONSHIP after delete not for replication
as begin
    delete from dbo.BBNCRELATIONSHIPIDMAP
        where RELATIONSHIPID in (select ID from deleted)
end