Physical Modeling › Constraints › Attaching a System Generated Default or Initial Value to a Column

Attaching a System Generated Default or Initial Value to a Column

You can attach the WITH DEFAULT option to a column, by selecting System Generated from the Default list in the Table Column Editor, and the DBMS applies a system-generated default value to the column based on the column's data type. The system-generated default values for a column with the WITH DEFAULT clause are database specific.

If the column names to be inserted and the insertion values are omitted during data loading using either the INSERT statement or the database creation utility, you must specify the WITH DEFAULT option when the default values are inserted into Non-Null constrained columns.

If you switch to a DBMS that does not support the WITH DEFAULT option, the WITH DEFAULT option is detached from all columns to which it is attached and deletes the system generated default value.