how to remove default constraint from column in Db2

sql db2 default-constraint
M.J. picture M.J. · Oct 4, 2011 · Viewed 11.4k times · Source

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.

Answer

M.J. picture M.J. · Oct 5, 2011

I tried with this and it worked properly

alter table STUDENT_TB alter DOB drop DEFAULT

Related questions

DB2 Query to retrieve all table names for a given schema

I'm just looking for a simple query to select all the table names for a given schema. For example, our DB has over 100 tables and I need to find any table that contains the sub-string “CUR”. I can use the …

Read More
show all tables in DB2 using the LIST command

This is embarrassing, but I can't seem to find a way to list the names of the tables in our DB2 database. Here is what I tried: root@VO11555:~# su - db2inst1 root@VO11555:~# . ~db2inst1/sqllib/db2profile …

Read More
DB2 Date format

I just want to format current date into yyyymmdd in DB2. I see the date formats available, but how can I use them? http://publib.boulder.ibm.com/infocenter/dzichelp/v2r2/index.jsp?topic=%2Fcom.ibm.db2z10.doc.…

Read More