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.
Rules and defaults are discussed in Chapter 14, “Defining Defaults and Rules for Data.” For complete information on, and syntax for, system procedures, see the Reference Manual.