Inserting Into Columns Without Specifying a Value - Teradata Database

Inserting Into Columns Without Specifying a Value

The following rules apply to an INSERT operation that does not assign values for every column in a new row:

If the column is not declared as NOT NULL and no default value is declared, nulls are inserted.

If the column is declared as NOT NULL and no default value is declared, an error is returned (ANSI session mode) or the transaction aborts (Teradata session mode).