Table Column Attributes
Creating and using your own datatypes
Syntax for sp_addtype system stored procedure
- Type is the name that you will give your new user-defined datatype.
- 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.
- Null_type is the NULL or NOT NULL keyword, if you choose to specify one. This must appear in quotes.