Create a custom user defined data type in sql server

You can use the CREATE TYPE syntax in SQL to create a custom data type.

The following SQL statement creates a custom data type "myDataType" of type nvarchar(50.

CREATE TYPE myDatatype
FROM nvarchar(50) NULL;

GO