| title | DROP SECURITY POLICY (Transact-SQL) | ||||
|---|---|---|---|---|---|
| description | DROP SECURITY POLICY a security policy for use with row-level security. | ||||
| author | VanMSFT | ||||
| ms.author | vanto | ||||
| ms.date | 10/04/2023 | ||||
| ms.service | sql | ||||
| ms.subservice | t-sql | ||||
| ms.topic | reference | ||||
| ms.custom |
|
||||
| f1_keywords |
|
||||
| helpviewer_keywords |
|
||||
| dev_langs |
|
||||
| monikerRange | =azuresqldb-current || >=sql-server-2016 || >=sql-server-linux-2017 || =azuresqldb-mi-current || =fabric || =fabric-sqldb |
[!INCLUDE sqlserver2016-asdb-asdbmi-fabricse-fabricdw-fabricsqldb]
Deletes a security policy.
:::image type="icon" source="../../includes/media/topic-link-icon.svg" border="false"::: Transact-SQL syntax conventions
DROP SECURITY POLICY [ IF EXISTS ] [schema_name. ] security_policy_name
[;]
Applies to: [!INCLUDE ssNoVersion] ( [!INCLUDE sssql16-md] through current version).
Conditionally drops the security policy only if it already exists.
Is the name of the schema to which the security policy belongs.
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.
Requires the ALTER ANY SECURITY POLICY permission and ALTER permission on the schema.
DROP SECURITY POLICY secPolicy;