CODEWITHSUNDEEP
sqldb2default-constraint
M.J.
M.J.

Reputation: 16646

how to remove default constraint from column in Db2

I had a table STUDENT_TB, which had column STUDENT_ID, NAME, AGE. I added a column with a following command :- 

alter table STUDENT_TB add DOB TIMESTAMP NOT NULL DEFAULT CURRENT TIMESTAMP

as for the DOB column i didn't wanted it to be null. Now i need to remove that default constraint.

I tried searching but not got any success.

Regards.

Upvotes: 5

Views: 12861

Answers (2)

M.J.
M.J.

Reputation: 16646

I tried with this and it worked properly

alter table STUDENT_TB alter DOB drop DEFAULT

Upvotes: 7

egbokul
egbokul

Reputation: 3974

ALTER TABLE STUDENT_TB ALTER COLUMN DOB DROP NOT NULL

Upvotes: 2

Related Questions