Ads were blocked - no problem. But keep in mind that developing HeidiSQL, user support and hosting takes time and money. You may want to send a donation instead.

Enumerate all CHECK Constraints from MariaDB

Snify's profile image Snify posted 1 year 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.