Re: HELP WITH DEFAULT CONSTRAINT

From: Peter Laursen <pl_at_mail1.remove.this.stofanet.dk>
Date: Tue, 9 Jan 2001 18:25:03 +0100
Message-ID: <oSH66.63$fa.3748@news101.telia.com>

Van Messner skrev i meddelelsen ...
>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?
>

The default default clause is NULL :-) So to 'drop' a default clause you have to set it back to NULL as in
alter table T modify(a default NULL)

Peter Laursen Received on Tue Jan 09 2001 - 11:25:03 CST