付録F.11 「SwitchPartition.sql」クエリスクリプト

USE [NETMDM_SAMPLE]
GO

ALTER TABLE netmdm_monitoring_security SWITCH PARTITION 1 TO netmdm_monitoring_security_arch PARTITION 1
GO

ALTER TABLE netmdm_monitoring_security SWITCH PARTITION 2 TO netmdm_monitoring_security_arch PARTITION 2
GO

ALTER TABLE netmdm_monitoring_security SWITCH PARTITION 3 TO netmdm_monitoring_security_arch PARTITION 3
GO

ALTER TABLE netmdm_monitoring_security SWITCH PARTITION 4 TO netmdm_monitoring_security_arch PARTITION 4
GO