/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

26 votes154 views10 answers
Insert in to table sql
SQL
0 vote205 views1 answer
Mysql cast null to string
SQL
0 vote208 views1 answer
<sql:datasource var="Snapsho"
SQL
0 vote211 views2 answers
Drop tables from local table database postgres
SQL
9 votes194 views4 answers
Mysql show table fields
SQL
0 vote223 views2 answers
Mysql dump structure only
SQL
2 votes190 views1 answer
Node and mysql like
SQL
0 vote207 views1 answer
Sql period overlap
SQL
-1 vote216 views2 answers
Postgres autoincrement primary key
SQL
0 vote198 views1 answer
Difference between varchar and varchar2
SQL