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