maria-developers team mailing list archive

[Sergei Golubchik <serg@xxxxxxxxxxx>]

Hi, Martijn!

On Jan 09, Martijn Tonies (Upscene Productions) wrote:
> Hi,
> 
> Where can I find meta information for check constraints on tables?

You can see the list of check constraints in
INFORMATION_SCHEMA.TABLE_CONSTRAINTS table.

Individual constraint definitions are currently only visible in SHOW
CREATE TABLE. They'll be in INFORMATION_SCHEMA.CHECK_CONSTRAINTS when
https://jira.mariadb.org/browse/MDEV-14474 will be implemented.

Regards,
Sergei
Chief Architect MariaDB
and security@xxxxxxxxxxx