DROP PARTITION SCHEME

Drop a partition function from the current database.

Syntax
      DROP PARTITION SCHEME ps_name [;]

Key
   ps_name     The partition scheme to drop.

This command requires that the partition scheme is not currently being used by any tables or indexes.

Example

DROP PARTITION SCHEME myRangePS;

"Most of the things we do have never been done before" - Enron corporate, 'who we are' statement

Related commands:

CREATE PARTITION SCHEME
ALTER PARTITION SCHEME

Equivalent Oracle command:

ALTER TABLE Partitioning clause