Events
Mar 31, 11 PM - Apr 2, 11 PM
The biggest SQL, Fabric and Power BI learning event. March 31 – April 2. Use code FABINSIDER to save $400.
Register todayThis browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
Applies to:
SQL Server
Azure SQL Managed Instance
Removes one or more user-defined rules from the current database.
Important
DROP RULE
will be removed in a future version of SQL Server. Don't use DROP RULE
in new development work, and plan to modify applications that currently use them. Instead, use CHECK
constraints that you can create by using the CHECK
keyword of CREATE TABLE or ALTER TABLE. For more information, see Unique Constraints and Check Constraints.
Transact-SQL syntax conventions
DROP RULE [ IF EXISTS ] { [ schema_name . ] rule_name } [ , ...n ]
[ ; ]
Applies to: SQL Server 2016 (13.x) and later versions
Conditionally drops the rule only if it already exists.
The name of the schema to which the rule belongs.
The rule to be removed. Rule names must comply with the rules for identifiers. Specifying the rule schema name is optional.
To drop a rule, first unbind it if the rule is currently bound to a column or to an alias data type. To unbind the rule, use sp_unbindrule
. If the rule is bound when you try to drop it, an error message is displayed and the DROP RULE
statement is canceled.
After a rule is dropped, new data entered into the columns previously governed by the rule is entered without the constraints of the rule. Existing data isn't affected in any way.
The DROP RULE
statement doesn't apply to CHECK
constraints. For more information about dropping CHECK
constraints, see ALTER TABLE.
To execute DROP RULE
, at a minimum, a user must have ALTER
permission on the schema to which the rule belongs.
The following example unbinds and then drops the rule named VendorID_rule
.
EXEC sp_unbindrule 'Production.ProductVendor.VendorID';
DROP RULE VendorID_rule;
Events
Mar 31, 11 PM - Apr 2, 11 PM
The biggest SQL, Fabric and Power BI learning event. March 31 – April 2. Use code FABINSIDER to save $400.
Register today