JP1/NETM/DM 構築ガイド (Windows(R)用)

[目次][用語][索引][前へ][次へ]

付録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