Nóta
Teastaíonn údarú chun rochtain a fháil ar an leathanach seo. Is féidir leat triail a bhaint as shíniú isteach nó eolairí a athrú.
Teastaíonn údarú chun rochtain a fháil ar an leathanach seo. Is féidir leat triail a bhaint as eolairí a athrú.
Applies to: 
SQL Server 2016 (13.x) and later versions
Azure SQL Database
Azure SQL Managed Instance
SQL analytics endpoint in Microsoft Fabric
Warehouse in Microsoft Fabric
SQL database in Microsoft Fabric
Deletes a security policy.
Transact-SQL syntax conventions
Syntax
DROP SECURITY POLICY [ IF EXISTS ] [schema_name. ] security_policy_name
[;]
Arguments
IF EXISTS
Applies to: SQL Server ( SQL Server 2016 (13.x) 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.
Examples
DROP SECURITY POLICY secPolicy;