Prev Next

NOT NULL Constraint

The NOT NULL constraint ensures that a column cannot have a NULL value. It is used to enforce that certain columns must always have a value.

Example: Using NOT NULL Constraint

CREATE TABLE FreedomFighters (
    FighterID INT PRIMARY KEY,
    Name VARCHAR(50) NOT NULL,
    City VARCHAR(50)
);

Explanation: The Name column cannot have NULL values, ensuring every fighter has a name.

Prev Next