I dont know if i am wrong but is there a easy way out for this.

May be if i say.

Partition function fx(10,20,30)

partition scheme sc on fx all to primary

Create Table blabla_bla ( i int primary Key scheme fx(i))on fx(i)

create table blabla_bla_mirror( i int primary Key scheme fx(i))on fx(i))

switch partiton x to blabla_bla_mirror (x)

your partition is empty now

drop table mirror.