Mega Code Archive

 

Categories / MSSQL Tutorial / Data Types

 

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