Syntax

object.BindRule( RuleOwner , RuleName , Bind )

Parts

object

Expression that evaluates to an object in the Applies To list

RuleOwner

String identifying the database user owning the bound rule

RuleName

String identifying the bound rule by name

Bind

TRUE or FALSE as described in Settings

Prototype (C/C++)

HRESULT BindRule(SQLDMO_LPCSTR RuleOwner,
SQLDMO_LPCSTR RuleName, BOOL Bind);

Settings

When Bind is TRUE, the rule named is bound to the column or user-defined data type referenced.

When Bind is FALSE, any rule is unbound from the referenced column or user-defined data type. The RuleOwner and RuleName properties are ignored.

Remarks

The BindRule method of the Column or UserDefinedDatatype objects, and the BindToColumn and BindToDatatype methods of the Rule object, associate a SQL Server rule with a user-defined data type or column.

The BindDefault method does not cause a check of existing values when a new rule is indicated for a column or user-defined data type.