Ravi Shekhar

Ravi Shekhar

  • 362
  • 4.5k
  • 2.1m

How to drop table partition in sql server

Aug 12 2013 7:24 AM

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.




Answers (3)