Yes . In the previous. chapter , we see how to generate "partition function" "parttiton schema" and "parttiton table"
- what can we do if we need to add or drop an table partition ?
- Here is exist status:
- /* add partition (oracle)== split partition (oracle,mssql) */
- /* drop parttiton (oracle) == merge partition (mssql) */
and
- Here we go
- /* add partitions */
- alter database test add filegroup TESTFG_201602;
- alter database test add file (name = TESTFG_201602,filename = "C:\var\opt\mssql\data\TESTFG_201602.ndf",size = 1MB,maxsize = unlimited,filegrowth = 1MB) to filegroup TESTFG_201602;
- go
- alter partition scheme PS_DATETIME_M_TEST NEXT USED TESTFG_201601;
- alter partition function PF_DATETIME_M_TEST() split range ( N'2016-01-02T00:00:00.000');
- go
- That script has an error. you would see if I execute it
However, It is right about "less than", because we use range right --- it will be talk about it in detail
- Let get into bussiness, hot to fix that ?
- Yes, we merge it
- /* drop partitions */
- alter partition function PF_DATETIME_M_TEST() merge range (N'2016-01-02T00:00:00.000');
- --alter database test remove file TESTFG_201602;
- --alter database test remove filegroup TESTFG_201602;
- then we can see that return
- and we can make it right
- alter partition scheme PS_DATETIME_M_TEST NEXT USED TESTFG_201602;
- alter partition function PF_DATETIME_M_TEST() split range ( N'2016-02-01T00:00:00.000');
- go
- Yes. we did it
来源: http://www.bubuko.com/infodetail-3423720.html