Re: HELP WITH DEFAULT CONSTRAINT

From: Sybrand Bakker <postbus_at_sybrandb.demon.nl>
Date: Tue, 9 Jan 2001 00:30:19 +0100
Message-ID: <93eg1m$9rtmd$1@ID-62141.news.dfncis.de>

1 default is not a constraint, it is an attribute of a column, check out default_value of user_tab_columns
2 I have never been able to get rid of a default myself. AFAIK both '' and NULL do not work.

Regards,

Sybrand Bakker, Oracle DBA

"Van Messner" <vmessner_at_bestweb.net> wrote in message news:PYq66.3165$iK.370092_at_monger.newsread.com...
> 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 - 17:30:19 CST