NOT NULL

Description

Prevents the columns from containing null values.

Click here to navigate to the IBM DB2 docs page for this syntax.

Grammar Syntax

NOT NULL

Sample Source Patterns

IBM DB2

Code

CREATE TABLE TABLE1 
(
 COL1 VARCHAR(15) NOT NULL,
 COL2 VARCHAR(15)
);

Snowflake

Code

CREATE TABLE TABLE1 
(
 COL1 VARCHAR(15) NOT NULL,
 COL2 VARCHAR(15)
);

Known issues

There are no known issues.