How to Set NOT NULL in SQL

1 year ago
Isabella Edwards
1 minute

When creating a table, you can add a NOT NULL constraint in the column definition to enforce a non-null constraint. For example:

CREATE TABLE Users (
    UserID INT NOT NULL,
    UserName VARCHAR(50) NOT NULL,
    Email VARCHAR(50) NOT NULL
);

In the example above, the columns UserID, UserName, and Email are all set to NOT NULL, which means that their values cannot be empty when inserting data. If an attempt is made to insert a null value or not provide a value, the database will reject the operation and throw an error.

bannerAds