Dropping not null constraint in db2 udb/WIn nt/unix

I have a table d ( f float not null). Is there any way I can drop the not null constraint from the table.
Thanks in advance.
Who is Participating?
ghp7000Connect With a Mentor Commented:
if this column is part of the primary key, you can drop the primary key and re create a new one.
if this column is not part of the primary key but you want to make it nullable, export the data from the table, re create the table as required, re load the data.
unfortunately the NULL/NOT NULL is a Column Option not a constraint from DB2/UDBs view on SQL

so you basicallt have to export and drop/recreate the table to change this...

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.