yes, stored in text field of "_MD_".TEXT table with text_type = 1.
anoop From: Dave Birdsall [mailto:[email protected]] Sent: Thursday, June 15, 2017 4:55 PM To: [email protected] Subject: RE: alter table add constraint ? modify constraint? TEXT table From: Eric Owhadi [mailto:[email protected]] Sent: Thursday, June 15, 2017 4:54 PM To: [email protected]<mailto:[email protected]> Subject: RE: alter table add constraint ? modify constraint? Check. BTW, I was trying to find them back in _MD_ schema. Do you happen to know where the constraint text is stored in _MD_ (assuming it is somewhere out there?) Eric From: Anoop Sharma [mailto:[email protected]] Sent: Thursday, June 15, 2017 6:51 PM To: [email protected]<mailto:[email protected]> Subject: RE: alter table add constraint ? modify constraint? 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]<mailto:[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
