yes, you need to drop/add constraint. There is no support for modify constraint.
constraint add/drop are transactionally protected. What kind of constraints are these? check, unique, RI? anoop From: Eric Owhadi [mailto:[email protected]] Sent: Thursday, June 15, 2017 4:30 PM To: [email protected] Subject: alter table add constraint ? modify constraint? Hi Trafodioneers, Looking at the doc, I don't see that there is syntax to modify a constraint. Should I assume that the only way to modify a constraint is to drop it first then add it back? Are these drop constraint, add constraint transactionaly protected? Thanks in advance for the help, Eric
