Home SQL Server Commands
 

DROP PARTITION FUNCTION

Drop a partition function from the current database.

Syntax
      DROP PARTITION FUNCTION pf_name [;]

Key
   pf_name     The partition function to drop.

This command requires that the partition function is not currently being used by any partition schemes.

Example

DROP PARTITION FUNCTION myRangePF;

"The best way to get a bad law repealed is to enforce it strictly" - Abraham Lincoln

Related commands:

CREATE PARTITION FUNCTION
ALTER PARTITION FUNCTION

Equivalent Oracle command:

ALTER TABLE Partitioning clause



Back to the Top

Simon Sheppard
SS64.com