How to drop table partition in sql server

Question

Hi i want to drop table partition in sql server 2008 r2. I am using below query... DROP PARTITION SCHEME dbo partition name abc and scheme name dbo. when i run above query i got below msg... Cannot drop the partition scheme 'abc' because it does not exist or you do not have permission. However i already set permission of admin. Help me.

Iftikar Hussain · Answer

check the below permission The following permissions can be used to execute DROP PARTITION SCHEME: 1. ALTER ANY DATASPACE permission. This permission defaults to members of the sysadmin fixed server role and the db_owner and db_ddladmin fixed database roles. 2. CONTROL or ALTER permission on the database in which the partition scheme was created. 3. CONTROL SERVER or ALTER ANY DATABASE permission on the server of the database in which the partition scheme was created. Regards Iftikar

Ravi Shekhar · Answer

I already tried sir... but same result

Iftikar Hussain · Answer

Hi try without dbo DROP PARTITION SCHEME abc Regards Iftikar