A rule specifies the acceptable values that can be inserted into that column. A column or alias data type can have only one rule bound to it but a column can have both a rule and one or more check constraints. Rules do not apply to data already existing in the database at the
time the rules are created. After you create a rule, execute sp_bindrule to bind the rule to a column or to alias data type. A rule cannot be bound to a text, ntext, image, varchar(max), nvarchar(max), varbinary(max), xml, CLR user-defined type, timestamp column and computed column. You can Create and Drop Rule but cannot ALTER. [Note: This feature will be removed in a future version of Microsoft SQL Server.]

Leave a Reply

Your email address will not be published. Required fields are marked *