Dimensi TutupBotol
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
Newer Post
Older Post
Home
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment