Copy Code Trigger Definition 

                
                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