skip to Main Content

I’m unable to find a place in PHPMyAdmin to see the list of check constraints.

I’m not talking about foreign key constraints, neither do I talk about indexes (unique or non-unique).

I want to manage check constraints.

I select a table, and go to Structure tab. There I can see the columns. I can move columns. I can manage indexes. I can go to Relation view and manage foreign keys. But I can’t find a link or tab to manage check constraints.

2

Answers


  1. It doesn’t seem to be supported by phpmyadmin.

    But you can try :

    SHOW CREATE TABLE table_name;

    (with fulltext option checked)

    Login or Signup to reply.
  2. Go to your Information Schema in PhpmyAdmin and click ‘Check Constraints’

    enter image description here

    Login or Signup to reply.
Please signup or login to give your own answer.
Back To Top
Search