The BindRule method implements Microsoft® SQL Server™ rule binding and unbinding for columns and user-defined data types.
| Column Object | UserDefinedDatatype Object |
object.BindRule( RuleOwner , RuleName , Bind )
| Part | Description |
|---|---|
| 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 |
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.
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.
HRESULT BindRule(SQLDMO_LPCSTR RuleOwner,
SQLDMO_LPCSTR RuleName, BOOL Bind);