FEAT: Check constraints doesn't appear on table properties

[expired user #9442]'s profile image [expired user #9442] posted 6 years ago in General Permalink

MySQL ignores CHECK constraints and SHOW CREATE TABLE doesn't show them after creation.

CREATE TABLE test (
country VARCHAR(25) NOT NULL CHECK (country IN ('US','UK'))
);

But MariaDB enforces CHECK constraints and SHOW CREATE TABLE returns it.

In HeidiSQL, there is no such place that we can see or ALTER check constraints. Fortunately they appear in db export.

Please add this function to HeidiSQL.

[expired user #9442]'s profile image [expired user #9442] posted 6 years ago Permalink

Ah, there is already an issue for that on github.

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