Create the User-Defined Datatypes

Before you create a table, create any user-defined datatypes.

The same is true of the p# datatype for the phone column:
execute sp_addtype nm, "varchar(30)" 
execute sp_addtype p#, "char(10)" 

The first two columns used in the sample table design are for the personal (first) name and surname. They are defined as the nm datatype.

The nm datatype allows for a variable-length character entry with a maximum of 30 bytes. The p# datatype allows for a char datatype with a fixed-length size of 10 bytes.