drop-partition-scheme-transact-sql.md

title	DROP PARTITION SCHEME (Transact-SQL) | Microsoft Docs
ms.custom
ms.date	03/06/2017
ms.prod	sql
ms.prod_service	sql-database
ms.component	t-sql|statements
ms.reviewer
ms.suite	sql
ms.technology	t-sql
ms.tgt_pltfrm
ms.topic	language-reference
f1_keywords	DROP PARTITION SCHEME DROP_PARTITION_SCHEME_TSQL
dev_langs	TSQL
helpviewer_keywords	DROP PARTITION SCHEME statement deleting partition schemes dropping partition schemes removing partition schemes partition schemes [SQL Server], removing
ms.assetid	6efbc87c-1c92-4e43-96a7-e0f30f1db185
caps.latest.revision	17
author	edmacauley
ms.author	edmaca
manager	craigg

DROP PARTITION SCHEME (Transact-SQL)

[!INCLUDEtsql-appliesto-ss2008-asdb-xxxx-xxx-md]

Removes a partition scheme from the current database. Partition schemes are created by using CREATE PARTITION SCHEME and modified by using ALTER PARTITION SCHEME.

Transact-SQL Syntax Conventions

Syntax

  
DROP PARTITION SCHEME partition_scheme_name [ ; ]  

Arguments

partition_scheme_name
Is the name of the partition scheme to be dropped.

Remarks

A partition scheme can be dropped only if there are no tables or indexes currently using the partition scheme. If there are tables or indexes using the partition scheme, DROP PARTITION SCHEME returns an error. DROP PARTITION SCHEME does not remove the filegroups themselves.

Permissions

The following permissions can be used to execute DROP PARTITION SCHEME:

• ALTER ANY DATASPACE permission. This permission defaults to members of the sysadmin fixed server role and the db_owner and db_ddladmin fixed database roles.

• CONTROL or ALTER permission on the database in which the partition scheme was created.

• CONTROL SERVER or ALTER ANY DATABASE permission on the server of the database in which the partition scheme was created.

Examples

The following example drops the partition scheme myRangePS1 from the current database:

DROP PARTITION SCHEME myRangePS1;  

See Also

CREATE PARTITION SCHEME (Transact-SQL)
ALTER PARTITION SCHEME (Transact-SQL)
sys.partition_schemes (Transact-SQL)
EVENTDATA (Transact-SQL)
sys.data_spaces (Transact-SQL)
sys.destination_data_spaces (Transact-SQL)
sys.partitions (Transact-SQL)
sys.tables (Transact-SQL)
sys.indexes (Transact-SQL)
sys.index_columns (Transact-SQL)