Data Types MSSQL Tutorial

  1. Home
  2. MSSQL Tutorial
  3. Data Types
  4. The syntax of the CREATE TYPE statement is as follows
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