AND ArchivedTime IS NULL OPEN relationship_partition FETCH NEXT FROM relationship_partition INTO @relationshipPartition WHILE ...

'
          AND ArchivedTime IS NULL
          OPEN relationship_partition
          FETCH NEXT FROM relationship_partition INTO @relationshipPartition
          WHILE @@fetch_status = 0
          BEGIN
            EXECUTE (N'ALTER TABLE dbo.[' + @relationshipPartition + N'] ADD ReferenceDataExtend NVARCHAR(896) NULL')
            
            FETCH NEXT FROM relationship_partition INTO @relationshipPartition
          END
          CLOSE relationship_partition
          DEALLOCATE relationship_partition
          GO

          -- Recreate completed instance view and all relationship view
          EXEC [dbo].[bam_Metadata_RegenerateViews] N'