The syntax of DataType is described in . The DataType can be omitted only if you specify a generation-clause. If you omit the DataType, the type of the generated column is the type of the generation-clause. If you specify both a DataType and a generation-clause, the type of the generation-clause must be assignable to DataType.

The syntaxes of Column-level-constraint and Table-level constraint are described in .

For the definition of a default value, a DefaultConstantExpression is an expression that does not refer to any table. It can include constants, date-time special registers, current schemas, users, roles, and null:

For details about Derby literal values, see .

The values in a DefaultConstantExpression must be compatible in type with the column, but a DefaultConstantExpression has the following additional type restrictions:

• If you specify USER, CURRENT_USER, SESSION_USER, or CURRENT_ROLE, the column must be a character column whose length is at least 8.
• If you specify CURRENT SCHEMA or CURRENT SQLID, the column must be a character column whose length is at least 128.
• If the column is an integer type, the default value must be an integer literal.
• If the column is a decimal type, the scale and precision of the default value must be within those of the column.