Personal tools
You are here: Home → DB2 → How To's → How to drop the column propriety 'not null' and column propriety default
Navigation
Log in


Forgot your password?
 
Document Actions

How to drop the column propriety 'not null' and column propriety default

set column null and unset or drop column propriety default

 

Dropping default

 db2 "alter table <schema_name>.<tab_name> alter column <column_name> drop default"

 

 

Dropping not null

 db2 "alter table <schema_name>.<tab_name> alter column <column_name> drop not null"
Security Awareness
Would you like your company to implement gamification into your security awareness program?





Polls