The syntax of the CREATE TYPE statement is as follows: : Create Type « Data Types « SQL Server / T-SQL Tutorial

1. SQL Server / T-SQL Tutorial
2. Data Types
3. Create Type

CREATE TYPE [type_schema_name.] type_name
      {[FROM base_type [(precision [,scale])] [NULL|NOT NULL]]
       |[EXTERNAL NAME assembly_name [.class_name]]}

10> CREATE TYPE zip
11>   FROM CHAR(5) NOT NULL
12> GO
1>
2> drop type zip;
3> GO