6.4 OMITNOTNULL | INCLUDENOTNULL

Use OMITNOTNULL and INCLUDENOTNULL to omit or include the words NOT NULL for columns that cannot contain null values. Assuming the column cannot be set to null, DDLGEN outputs the following definitions:

  • If INCLUDENOTNULL (or nothing) is specified:

    COL CHAR (10) NOT NULL
    
  • If OMITNOTNULL is specified:

    COL CHAR (10) 
    

The default templates for each supported database already include the correct setting for this argument.

Default

INCLUDENOTNULL

Syntax

OMITNOTNULL | INCLUDENOTNULL