This is the grammar copied from SQL-2011:
<row type> ::= ROW <row type body> <row type body> ::= <left paren> <field definition> [ { <comma> <field definition> }... ] <right paren> <field definition> ::= <field name> <data type>
We extend the grammar for every field data type to have an optional suffix:
<field definition> ::= <field name> <data type> [ [ NULL | NOT NULL] ]
The suffix is used to indicate if this field is nullable; To keep sync with other data types, the default is not nullable.
- links to