Associate Rules and Defaults with User-Defined Datatypes

Once you have created a user-defined datatype, use sp_bindrule and sp_bindefault to associate rules and defaults with the datatype. Use sp_help to print a report that lists the rules, defaults, and other information associated with the datatype.

Related concepts
Defining Defaults and Rules for Data