sql server 分區表資料移轉中switch的應用

-- create partition function
CREATE PARTITION FUNCTION partRange1 (INT)
AS RANGE LEFT FOR VALUES (10, 20, 30) ;
GO
-- create partition scheme
CREATE PARTITION SCHEME partScheme1
AS PARTITION partRange1
ALL TO ([PRIMARY]) ;
GO
-- create table that uses this partitioning scheme
CREATE TABLE partTable (col1 INT, col2 VARCHAR(20))
ON partScheme1 (col1) ;
GO
--查詢分區情況
SELECT *
FROM sys.partitions
WHERE OBJECT_ID = OBJECT_ID('partTable')
GO
-- insert some sample data
INSERT INTO partTable (col1, col2) VALUES (5, 'partTable')
INSERT INTO partTable (col1, col2) VALUES (6, 'partTable')
INSERT INTO partTable (col1, col2) VALUES (7, 'partTable')
GO
-- select the data
SELECT * FROM partTable
go
-- switch in
CREATE TABLE newPartTable (col1 INT CHECK (col1 > 30 AND col1