The default is NULL except when you copy a table definition using the CREATE TABLE … AS syntax, in which case the system carries the specification made for the source table over to the target table definition.
- NOT
- You must specify NOT NULL if you do not want nulls to be valid for the column.