Skip to Main Content
Forums

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Dropping a column's default value

443353Apr 17 2006 — edited Feb 20 2010
How to drop a column's default value?
The following commands fails:
ALTER TABLE t1 ALTER COLUMN c1 DROP DEFAULT.
ALTER TABLE t1 MODIFY c1 DROP DEFAULT.

Thanks in advance.
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Mar 20 2010
Added on Apr 17 2006
#general-database-discussions
16 comments
84,174 views