How to drop table partition in sql server

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 Shekhar13y ago

I already tried sir... but same result

Iftikar Hussain13y ago

Hi,
try without dbo

DROP PARTITION SCHEME abc

Regards,
Iftikar