SQL NOT NULL Constraint
The NOT NULL constraint enforces a field or column to not contain a null value.
Example of NOT NULL constraint with CREATE TABLE statement:
CREATE TABLE PERSONS (
P_ ID INT NOT NULL,
NAME VARCHAR (20) NOT NULL,
PRIMARY KEY (P_ID)
Example of NOT NULL constraint with ALTER TABLE statement:
ALTER TABLE PERSONS MODIFY AGE INT NOT NULL;
Next Topic: SQL UNIQUE Constraint with example.
Previous Topic: SQL FOREIGN KEY with example.