Bind Rule/Default to User-defined Data Types
Use this dialog box to view or specify the following options.
Options
Rule
View the name of the rule that you wish to bind to a user-defined data type. When bound to a column or a user-defined data type, a rule specifies the acceptable values that can be inserted into that column. Rules, a backward compatibility feature, perform some of the same functions as check constraints. CHECK constraints, created using the CHECK keyword of ALTER or CREATE TABLE, are the preferred, standard way to restrict the values in a column (multiple constraints can be defined on a column or multiple columns). A column or user-defined data type can have only one rule bound to it. However, a column can have both a rule and one or more check constraints associated with it. When this is true, all restrictions are evaluated. For more information about rules, see CREATE RULE.
Name
View the name and data type of the user-defined data type. Select each rule to bind, by checking the Bind box. Selecting the Future Only box prevents existing columns of a user-defined data type from inheriting the new rule. If Future Only is selected, the new rule is bound to any columns of the user-defined data type that currently have no rule or that are using the existing rule of the user-defined data type. For more information about binding rules, see sp_bindrule.