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

          -- Erneutes Erstellen der abgeschlossenen Instanzsicht und aller Beziehungssichten
          EXEC [dbo].[bam_Metadata_RegenerateViews] N'
English
English (United States)
Deutsch (Deutschland)
German (Germany)
Español (España)
Spanish (Spain)
Français (France)
French (France)
日本語
Japanese
한국어
Korean