Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: How to remove a default value from a column
Try - Alter tabe taba modify col1 default null;
Seems to me that is all it takes!
Becca
> Probably a simple one;
>
> Does anybody know how to remove a default value from a
column?
>
> Thanks in advance, Jean-Luc
>
>
>
>
>
>
--
This answer is courtesy of QuestionExchange.com
http://www.questionexchange.com/showUsenetGuest.jhtml?ans_id=4477&cus_id=USENET&qtn_id=3647
Received on Mon Oct 11 1999 - 08:04:03 CDT