/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

3 votes269 views2 answers
Sql asc
SQL
0 vote253 views1 answer
Oracle enable chain
SQL
0 vote279 views1 answer
Materialized view redshift
SQL
1 vote282 views2 answers
Postgresql truncate cascade restart identity
SQL
0 vote273 views1 answer
5.Query to raise salary of all employees with 300 in EMP table and display name and salary as new sal from EMP table employee name, job, and salary from EMP table.
SQL
1 vote424 views3 answers
Create table from existing table in sql
SQL
6 votes263 views4 answers
How to remove unique key in mysql
SQL
0 vote261 views1 answer
Get records in sql according to month name and count
SQL
1 vote289 views1 answer
Mysql text to decimal
SQL
0 vote310 views1 answer
Kimball data warehouse sql calendar
SQL