Thursday, September 19, 2019

Remove NOT NULL Constraint in Postgresql Using SQL Script

So I have a table called 'changes' with column name 'test' and it's constraint as 'NOT NULL'

To remove NOT NULL constraint, just execute this script in pgAdmin :


alter table changes alter column test drop not null;

Result :

No comments:

Post a Comment