Search
 
SCRIPT & CODE EXAMPLE
 
CODE EXAMPLE FOR SQL

SQL Remove NOT NULL Constraint

#SQL Server

ALTER TABLE Customers
ALTER COLUMN age INT;

#Oracle

ALTER TABLE Customers
MODIFY (age NULL);

#MySQL

ALTER TABLE Customers
MODIFY age INT;

#PostgreSQL

ALTER TABLE Customer
ALTER COLUMN age DROP NOT NULL;
 
PREVIOUS NEXT
Tagged: #SQL #Remove #NOT #NULL #Constraint
ADD COMMENT
Topic
Name
8+9 =