TR_RELATIONSHIP_DELETE_BBNCRELATIONSHIPIDMAP (Trigger)

                
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