Table Column Attributes  «Prev 

Syntax for sp_addtype system stored procedure

Data Type
Data Type

  1. Type is the name that you will give your new user-defined datatype.
  2. System_data_type is the existing MS SQL Server 2012 datatype that you will use in creating your user-defined datatype. This must appear in quotes.
  3. Null_type is the NULL or NOT NULL keyword, if you choose to specify one. This must appear in quotes.