drop-partition-function-transact-sql.md

title	DROP PARTITION FUNCTION (Transact-SQL) | Microsoft Docs
ms.custom
ms.date	03/06/2017
ms.prod	sql-non-specified
ms.prod_service	sql-database
ms.service
ms.component	t-sql|statements
ms.reviewer
ms.suite	sql
ms.technology	database-engine
ms.tgt_pltfrm
ms.topic	language-reference
f1_keywords	DROP PARTITION FUNCTION DROP_PARTITION_FUNCTION_TSQL
dev_langs	TSQL
helpviewer_keywords	deleting partition functions DROP PARTITION FUNCTION statement partition functions [SQL Server], removing dropping partition functions removing partition functions
ms.assetid	a4bb055a-a538-4db9-a6fb-550d1eabfa18
caps.latest.revision	31
author	edmacauley
ms.author	edmaca
manager	craigg
ms.workload	On Demand

DROP PARTITION FUNCTION (Transact-SQL)

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

Removes a partition function from the current database. Partition functions are created by using CREATE PARTITION FUNCTION and modified by using ALTER PARTITION FUNCTION.

Transact-SQL Syntax Conventions

Syntax

  
DROP PARTITION FUNCTION partition_function_name [ ; ]  

Arguments

partition_function_name
Is the name of the partition function that is to be dropped.

Remarks

A partition function can be dropped only if there are no partition schemes currently using the partition function. If there are partition schemes using the partition function, DROP PARTITION FUNCTION returns an error.

Permissions

Any one of the following permissions can be used to execute DROP PARTITION FUNCTION:

• 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 function was created.

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

Examples

The following example assumes the partition function myRangePF has been created in the current database.

DROP PARTITION FUNCTION myRangePF;  

See Also

CREATE PARTITION FUNCTION (Transact-SQL)
ALTER PARTITION FUNCTION (Transact-SQL)
EVENTDATA (Transact-SQL)
sys.partition_functions (Transact-SQL)
sys.partition_parameters (Transact-SQL)
sys.partition_range_values (Transact-SQL)
sys.partitions (Transact-SQL)
sys.tables (Transact-SQL)
sys.indexes (Transact-SQL)
sys.index_columns (Transact-SQL)