/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 vote278 views1 answer
Grant privileges of databse to user
SQL
0 vote271 views1 answer
Exit psql
SQL
-1 vote271 views1 answer
Pl sql drop trigger
SQL
0 vote281 views1 answer
LoadError: cannot load such file -- mysql2/2.7/mysql2
SQL
5 votes272 views3 answers
Sql server utc to local
SQL
1 vote301 views2 answers
Laravel jwt generate token
SQL
1 vote268 views1 answer
Postgresql export output table as a csv
SQL
-2 votes250 views3 answers
Oracle tablespace usage
SQL
2 votes277 views3 answers
Mysql kill
SQL
-1 vote281 views1 answer
Brisanje dupliranih konatakata
SQL