yes, stored in text field of "_MD_".TEXT table with text_type = 1.
anoop From: Dave Birdsall [mailto:dave.birds...@esgyn.com] Sent: Thursday, June 15, 2017 4:55 PM To: user@trafodion.incubator.apache.org Subject: RE: alter table add constraint ? modify constraint? TEXT table From: Eric Owhadi [mailto:eric.owh...@esgyn.com] Sent: Thursday, June 15, 2017 4:54 PM To: user@trafodion.incubator.apache.org<mailto:user@trafodion.incubator.apache.org> 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:anoop.sha...@esgyn.com] Sent: Thursday, June 15, 2017 6:51 PM To: user@trafodion.incubator.apache.org<mailto:user@trafodion.incubator.apache.org> 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:eric.owh...@esgyn.com] Sent: Thursday, June 15, 2017 4:30 PM To: user@trafodion.incubator.apache.org<mailto:user@trafodion.incubator.apache.org> 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
