Setting field defaults
The Field Default group allows you to define the default value for the column, i.e. the value that is entered when no other entry is made
To activate the group, enable the Field Default option.
Use the provided controls to specify the default field value.
The Field Default edit controls vary according to the data type of the field being edited:
- for integral data types (SMALLINT, INTEGER), use the Default spinner control to specify the necessary value
- for floating-point data types (FLOAT, NUMERIC, DOUBLE PRECISION, DECIMAL), type in or click the arrow-down button to call the Calculator popup window and set the necessary value
- for string data types (CHAR, VARCHAR), use the editable area to input the necessary text
- for temporal data types (DATE, TIME), type in or click the arrow-down button to call the Date editor popup window and set the required date value; if necessary, check Set default value to and select a NOW/TODAY value from the drop-down list
When the Not Null option is enabled, the Field Value by Default dialog appears before applying changes to prevent the NOT NULL constraint violation.
Source of data
Implies that values for the field are taken from an existing field. Use the Field drop-down list to select the field to be used as the source for the field being created/edited.
Value is direct
Implies that the default value for the field is specified directly. Use the Value box to set the value you need.