Yep,
ALTER TABLE MODIFY( DEFAULT NULL);
Works so I guess its ok. Was hoping to completely remove
Thanks All.
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author:
INET: [EMAIL PROTECTED]
Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051
San Diego,
[EMAIL PROTECTED]Subject: Syntax For Dropping a default
value?
try this:
alter table
modify
default null;
-Original Message-
Sent: Friday, May 03, 2002 11:13 AM
To: Multiple recipients of list ORACLE-L
Hi,
Been searching for syntax to drop a default value (we decided NOT to
use the default value) for a colmun.
I looked in the docs an
Hi,
Been searching for syntax to drop a default value (we decided NOT to use the
default value) for a colmun.
I looked in the docs and even tried to remove the default value via DBA Studio.
No go. Can you not modify a column to REMOVE a default value specification?
Thanks,