Alle Sichten in einer Microsoft-SQL-Server-Datenbank aktualisieren
Um alle Views in einem Rutsch zu aktualisieren, hilft folgender Code: DECLARE @view AS VARCHAR(255); DECLARE views_cursor CURSOR FOR SELECT TABLE_SCHEMA + ‚.‘ +TABLE_NAME FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_TYPE = ‚VIEW‘ AND OBJECTPROPERTY(OBJECT_ID(TABLE_NAME), ‚IsMsShipped‘) = 0 ORDER BY TABLE_SCHEMA,TABLE_NAME OPEN views_cursor FETCH NEXT…