Monday, 9 June 2014

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

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"

No comments:

Post a Comment