/SQL/How to add not null constraint in sql

How to add not null constraint in sql

ALTER TABLE table_name MODIFY column_name datatype NOT NULL;

Source: tutorialspoint.com

NOT NULL SQL

By default, a column can hold NULL values.
The NOT NULL constraint enforces a column to NOT accept NULL values.
This enforces a field to always contain a value, which means that you cannot insert a new record, or update a record without adding a value to this field.

Sql NOT NULL in creating a table
CREATE TABLE Persons (
    ID int NOT NULL,
    LastName varchar(255) NOT NULL,
    FirstName varchar(255) NOT NULL,
    Age int
);

Similar codes

0 vote122 views2 answers
SQLSTATE[HY000]: General error: 3780 Referencing column 'role_id' and referenced column 'id' in foreign key constraint 'user_role_id foreign' are incompatible.
SQL
2 votes128 views1 answer
Oracle trace file
SQL
1 vote113 views1 answer
Drop function
SQL
6 votes1.2K views1 answer
Sql select second max
SQL
26 votes350 views6 answers
Modify column name in sql
SQL
3 votes99 views1 answer
MySQL DELETE JOIN
SQL
1 vote111 views1 answer
Find difference in dates sql
SQL
0 vote113 views1 answer
Ksql quickstart docker
SQL
0 vote106 views2 answers
Sqlite unix timestamp
SQL
0 vote106 views1 answer
Pl/sql loop example
SQL