SELECT * FROM `TABLE_CONSTRAINTS`
CONSTRAINT_CATALOG | CONSTRAINT_SCHEMA | CONSTRAINT_NAME | TABLE_SCHEMA | TABLE_NAME | CONSTRAINT_TYPE | |
---|---|---|---|---|---|---|
def | mysql | PRIMARY | mysql | columns_priv | PRIMARY KEY | |
def | mysql | PRIMARY | mysql | db | PRIMARY KEY | |
def | mysql | PRIMARY | mysql | event | PRIMARY KEY | |
def | mysql | PRIMARY | mysql | func | PRIMARY KEY | |
def | mysql | PRIMARY | mysql | help_category | PRIMARY KEY | |
def | mysql | name | mysql | help_category | UNIQUE | |
def | mysql | PRIMARY | mysql | help_keyword | PRIMARY KEY | |
def | mysql | name | mysql | help_keyword | UNIQUE | |
def | mysql | PRIMARY | mysql | help_relation | PRIMARY KEY | |
def | mysql | PRIMARY | mysql | help_topic | PRIMARY KEY | |
def | mysql | name | mysql | help_topic | UNIQUE | |
def | mysql | PRIMARY | mysql | innodb_index_stats | PRIMARY KEY | |
def | mysql | PRIMARY | mysql | innodb_table_stats | PRIMARY KEY | |
def | mysql | PRIMARY | mysql | ndb_binlog_index | PRIMARY KEY | |
def | mysql | PRIMARY | mysql | plugin | PRIMARY KEY | |
def | mysql | PRIMARY | mysql | proc | PRIMARY KEY | |
def | mysql | PRIMARY | mysql | procs_priv | PRIMARY KEY | |
def | mysql | PRIMARY | mysql | proxies_priv | PRIMARY KEY | |
def | mysql | PRIMARY | mysql | servers | PRIMARY KEY | |
def | mysql | PRIMARY | mysql | slave_master_info | PRIMARY KEY | |
def | mysql | PRIMARY | mysql | slave_relay_log_info | PRIMARY KEY | |
def | mysql | PRIMARY | mysql | slave_worker_info | PRIMARY KEY | |
def | mysql | PRIMARY | mysql | tables_priv | PRIMARY KEY | |
def | mysql | PRIMARY | mysql | time_zone | PRIMARY KEY | |
def | mysql | PRIMARY | mysql | time_zone_leap_second | PRIMARY KEY |