Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> HELP WITH DEFAULT CONSTRAINT
I have a table with a default constraint of sysdate on a date column. I want to drop the default. When I look at the constraints on the table, I don't see the default constraint. When I do an alter table X modify(column with no default) the default constraint remains in place. I'm probably missing something obvious, but how do I get rid of the default?
Thanks,
Van Received on Mon Jan 08 2001 - 16:14:07 CST