SQL

how to add not null constraint in sql

ALTER TABLE table_name MODIFY column_name datatype NOT NULL;

add not null constraint sql server

ALTER TABLE table1 ALTER COLUMN column1 datatype NOT NULL;

SQL NOT NULL Constraint

CREATE TABLE Colleges (
  college_id INT NOT NULL,
  college_code VARCHAR(20),
  college_name VARCHAR(50)
);

SQL NOT NULL Constraint

CREATE TABLE Persons (
    ID int NOT NULL,
    LastName varchar(255) NOT NULL,
    FirstName varchar(255) NOT NULL,
    Age int
);

not null constraint

ID int(10) NOT NULL;

SQL NOT NULL Constraint

CREATE TABLE Colleges (
  college_id INT NOT NULL,
  college_code VARCHAR(20) NOT NULL,
  college_name VARCHAR(50)
);