/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 vote126 views1 answer
Mysql 8 geo to json
SQL
0 vote110 views3 answers
Joins and views sql
SQL
0 vote118 views1 answer
An exception occurred while executing a transact-sql statement or batch user,group or role already
SQL
6 votes114 views1 answer
Oracle list primary key
SQL
8 votes113 views1 answer
How to remove tables from postgresql
SQL
1 vote131 views1 answer
Mysql workbench in ubuntu 14.04
SQL
0 vote140 views1 answer
Mariadb.service failed with result 'exit-code'
SQL
58 votes284 views6 answers
Create new user in postgres
SQL
1 vote107 views1 answer
Sql server 2016 reseed identity
SQL
0 vote132 views2 answers
SQL Server log file truncate - Source :NAYCode.com
SQL