Enumerate all CHECK Constraints from MariaDB

[expired user #11879]'s profile image [expired user #11879] posted 5 years ago in Feature discussion Permalink

I love HeidiSQL! Since I am a beginner, I can not find a way to show or create a CHECK Constraint with HeidiSQL and MariaDB 10.3.8.

The only way to create one is by manually write a CHECK constraint in the console. Also, the only way to enumerate ALL CHECK Constraints for a table is to call " SHOW CREATE TABLE" (Which is not a big deal at all!) (But I would have at least expected, to have all the CHECK Constraints in the "CREATE Code" Tab... I guess the tab does NOT call "SHOW CREATE")

Could you please add this feature to HeidiSQL?

Thank you in advance :)

Please login to leave a reply, or register at first.