maria-developers team mailing list archive
Mailing list archive
Re: Check constraints
On Jan 09, Martijn Tonies (Upscene Productions) wrote:
Where can I find meta information for check constraints on tables?
You can see the list of check constraints in
I noticed they are listed, yes, but not with a definition.
Individual constraint definitions are currently only visible in SHOW
Well, that is... not quite ideal.
They'll be in INFORMATION_SCHEMA.CHECK_CONSTRAINTS when
https://jira.mariadb.org/browse/MDEV-14474 will be implemented.
But version 10.2 is the release version, right? I'm surprised that this
has been released without such functionality. As a tool developer and
as a database developer, I'd say this MDEV-14474 would be a
requirement before a stable release is ready.
I've checked with both MySQL and MariaDB 10.2, this 12 year old issue
hasn't changed either:
Meta data information is very important.
Database Workbench - developer tool for Oracle, MS SQL Server, PostgreSQL,
SQL Anywhere, MySQL, InterBase, NexusDB and Firebird.