- 论坛徽章:
- 0
|
都可以,"drop partition"要多几步。注意分区变动需要drop index first。
1> alter table Client partition by range (ClientUserID)
2> (ptn1 values<=(4000000),
3> ptn2 values<=(7000000),
4> ptn3 values<=(10000000))
5> go
(2 rows affected)
1> alter table Client partition by roundrobin(ClientUserID)
2> go
(2 rows affected)
1> alter table Client partition by range (ClientUserID)
2> (ptn1 values<=(4000000),
3> ptn2 values<=(7000000),
4> ptn3 values<=(10000000))
5> go
(2 rows affected)
1> alter table Client drop partition ptn3
2> go
1> alter table Client drop partition ptn2
2> go
1> alter table Client drop partition ptn1
2> go
Msg 13968, Level 16, State 1:
Server 'TOP_DBA', Line 1:
ALTER TABLE 'Client' failed. You cannot drop all partitions of a table.
|
|