How can a not null constraint be dropped?
Posted
by Tomislav Nakic-Alfirevic
on Stack Overflow
See other posts from Stack Overflow
or by Tomislav Nakic-Alfirevic
Published on 2010-04-09T13:25:00Z
Indexed on
2010/04/09
14:03 UTC
Read the original article
Hit count: 452
Let's say there's a table created as follows:
create table testTable ( colA int not null )
How would you drop the not null constraint? I'm looking for something along the lines of
ALTER TABLE testTable ALTER COLUMN colA DROP NOT NULL;
which is what it would look like if I used PostgreSQL. To my amazement, as far as I've been able to find, the MySQL docs, Google and yes, even Stackoverflow (in spite of dozens or hundreds of NULL-related questions) don't seem to lead towards a single simple SQL statement which will do the job.
© Stack Overflow or respective owner
