sys.sp_unbindrule

Description

Unbinds a rule from a column or an alias data type in the current database.

Syntax

sp_unbindrule
[ @objname = ]
N
'objname'
[ , [ @futureonly = ]
'futureonly'
]
[ ; ]

Examples

Example 1

sp_unbindrule

Example 2

DROP RULE

Example 3

DROP RULE

Example 4

CHECK

Example 5

CHECK

Example 6

DROP RULE

Example 7

ALTER

Example 8

VendorID_rule

Example 9

EXEC sp_unbindrule 'Production.ProductVendor.VendorID';
DROP
RULE VendorID_rule;

Example 10

CREATE RULE
DROP RULE sp_bindrule sp_unbindrule
CHECK

(. and 30 more examples)