drop-security-policy-transact-sql.md

title	DROP SECURITY POLICY (Transact-SQL) | Microsoft Docs
ms.custom	SQL2016_New_Updated
ms.date	05/11/2017
ms.prod	sql-non-specified
ms.reviewer
ms.suite
ms.technology	database-engine
ms.tgt_pltfrm
ms.topic	language-reference
f1_keywords	DROP_SECURITY_POLICY_TSQL DROP SECURITY POLICY DROP SECURITY DROP_SECURITY_TSQL
dev_langs	TSQL
helpviewer_keywords	DROP SECURITY POLICY statement
ms.assetid	5bd3393d-2fa5-4db0-a69a-a1a72d638e9d
caps.latest.revision	8
author	BYHAM
ms.author	rickbyh
manager	jhubbard

DROP SECURITY POLICY (Transact-SQL)

[!INCLUDEtsql-appliesto-ss2016-asdb-xxxx-xxx_md]

Deletes a security policy.

Transact-SQL Syntax Conventions

Syntax

DROP SECURITY POLICY [ IF EXISTS ] [schema_name. ] security_policy_name    
[;]  

Arguments

IF EXISTS
Applies to: [!INCLUDEssNoVersion] ([!INCLUDEssSQL15] through current version).

Conditionally drops the security policy only if it already exists.

schema_name
Is the name of the schema to which the security policy belongs.

security_policy_name
The name of the security policy. Security policy names must comply with the rules for identifiers and must be unique within the database and to its schema.

Remarks

Permissions

Requires the ALTER ANY SECURITY POLICY permission and ALTER permission on the schema.

Example

DROP SECURITY POLICY secPolicy;  

See Also

Row-Level Security
CREATE SECURITY POLICY (Transact-SQL)
ALTER SECURITY POLICY (Transact-SQL)
sys.security_policies (Transact-SQL)
sys.security_predicates (Transact-SQL)