Before you create a table, create any user-defined datatypes.
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.