Create a custom user defined data type in sql server

This blog shows on how to 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