Default value

Specifies a default value for the column. This default value is used when rows are inserted into the table without specifying data for the column. You cannot assign a default value to a column that is defined as an identity column or as a ROWID.

NULL: The system assigns a default value of NULL. This option is only available if the column is nullable.

No default
Indicates that the column does not have a default value. This option is only available if the column is not nullable.

Data type default
The system assigns a default value depending on the data type of the column. The system assigned default value for a column with a type of CHARACTER or VARCHAR is an empty string ("). The system assigned default value for a numeric type is the null value if the column is nullable or the column data type default if the column is not nullable.

USER special register value
The system inserts the profile name of the current user. The USER option is only available to columns of type CHARACTER or VARCHAR with lengths of 18 or greater. The USER option is available on Version 4 Release 2 or later systems.

Current date
The current date is inserted by the system. This option is only available to columns of type DATE.

Current time
The current time is inserted by the system. This option is only available to columns of type TIME.

Current timestamp
The current timestamp is inserted by the system. This option is only available to columns of type TIME.

You can specify your own default value by entering a value into the field. The value you enter must be valid for the column data type.