1 CREATE TYPE [ schema_name. ] type_name
 2 { 
 3     FROM base_type 
 4     [ ( precision [ , scale ] ) ]
 5     [ NULL | NOT NULL ] 
 6   | EXTERNAL NAME assembly_name [ .class_name ] 
 7   | AS TABLE ( { <column_definition> | <computed_column_definition> }
 8         [ <table_constraint> ] [ ,...n ] )  
 9 } [ ; ]
10 
11 <column_definition> ::= 
12 column_name <data_type>
13     [ COLLATE collation_name ] 
14     [ NULL | NOT NULL ]
15     [ 
16         DEFAULT constant_expression ] 
17       | [ IDENTITY [ ( seed ,increment ) ] 
18     ]
19     [ ROWGUIDCOL ] [ <column_constraint> [ ...n ] ] 
20 
21 <data type> ::= 
22 [ type_schema_name . ] type_name 
23     [ ( precision [ , scale ] | max | 
24                 [ { CONTENT | DOCUMENT } ] xml_schema_collection ) ] 
25 
26 <column_constraint> ::= 
27 {     { PRIMARY KEY | UNIQUE } 
28         [ CLUSTERED | NONCLUSTERED ] 
29         [ 
30             WITH ( <index_option> [ ,...n ] ) 
31         ]
32   | CHECK ( logical_expression ) 
33 } 
34 
35 <computed_column_definition> ::= 
36 column_name AS computed_column_expression 
37 [ PERSISTED [ NOT NULL ] ]
38 [ 
39     { PRIMARY KEY | UNIQUE }
40         [ CLUSTERED | NONCLUSTERED ]
41         [ 
42             WITH ( <index_option> [ ,...n ] )
43         ]
44     | CHECK ( logical_expression ) 
45 ] 
46 
47 <table_constraint> ::=
48 { 
49     { PRIMARY KEY | UNIQUE } 
50         [ CLUSTERED | NONCLUSTERED ] 
51                               ( column [ ASC | DESC ] [ ,...n ] ) 
52         [ 
53            WITH ( <index_option> [ ,...n ] ) 
54         ]
55     | CHECK ( logical_expression ) 
56 } 
57 
58 <index_option> ::=
59 { 
60     IGNORE_DUP_KEY = { ON | OFF } 
61 }