Dropping of Partition in SQL SERVER

Drop a Partition Function

To drop a partition function it should not have any partition scheme associated with it.

The Syntax is as follows

  DROP PARTITION FUNCTION < Partition Function Name >

The below example shows how to drop a partition function

  DROP PARTITION FUNCTION EmployeePartitionLeft

Drop a Partition Scheme

To drop a partition scheme it should not have any table associated with it.

The Syntax is as follows

  DROP PARTITION SCHEME < Partition Scheme Name >

The below example shows how to drop a partition scheme

  DROP PARTITION SCHEME EmployeePartitionScheme