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!

what happens if we drop a constraint?

user8596912May 12 2014 — edited May 12 2014

Hi all,

I have a table which has more 10k rows in it and it is in production database, I got a request to drop a constraint.

What happens if we drop a constraint from a big table?

What will be the impact?

With a constraint like test_chk where it checks for a value between 1 and 9999, could a null be in that field?

This post has been answered by Greg Spall on May 12 2014

Jump to Answer

Locked Post

New comments cannot be posted to this locked post.

Locked on Jun 9 2014

Added on May 12 2014

#general-database-discussions, #index, #table

7 comments

1,506 views