Hi Eric, There doesn't appear to be.
I noticed the SQL parser does have such syntax, but the productions return an error if invoked. So someone thought about implementing ALTER TABLE <table> DISABLE ALL CONSTRAINTS at one point but did not complete it. Just curious: What's the use case? Why does dropping and then recreating not work? Dave From: Eric Owhadi [mailto:eric.owh...@esgyn.com] Sent: Friday, June 16, 2017 8:35 AM To: user@trafodion.incubator.apache.org Subject: is there a way to disable a specific check constraint without dropping it? Hi Trafodioneers, I am wondering if there is a way to disable check constraint without dropping them? Is there? Thanks in advance for the help, Eric