SELECT * FROM `TABLE_CONSTRAINTS`
|
CONSTRAINT_CATALOG | CONSTRAINT_SCHEMA | CONSTRAINT_NAME | TABLE_SCHEMA | TABLE_NAME | CONSTRAINT_TYPE | ENFORCED | |
---|---|---|---|---|---|---|---|
def | mysql | PRIMARY | mysql | columns_priv | PRIMARY KEY | YES | |
def | mysql | PRIMARY | mysql | component | PRIMARY KEY | YES | |
def | mysql | PRIMARY | mysql | db | PRIMARY KEY | YES | |
def | mysql | PRIMARY | mysql | default_roles | PRIMARY KEY | YES | |
def | mysql | PRIMARY | mysql | engine_cost | PRIMARY KEY | YES | |
def | mysql | PRIMARY | mysql | func | PRIMARY KEY | YES | |
def | mysql | PRIMARY | mysql | global_grants | PRIMARY KEY | YES | |
def | mysql | PRIMARY | mysql | gtid_executed | PRIMARY KEY | YES | |
def | mysql | name | mysql | help_category | UNIQUE | YES | |
def | mysql | PRIMARY | mysql | help_category | PRIMARY KEY | YES | |
def | mysql | name | mysql | help_keyword | UNIQUE | YES | |
def | mysql | PRIMARY | mysql | help_keyword | PRIMARY KEY | YES | |
def | mysql | PRIMARY | mysql | help_relation | PRIMARY KEY | YES | |
def | mysql | name | mysql | help_topic | UNIQUE | YES | |
def | mysql | PRIMARY | mysql | help_topic | PRIMARY KEY | YES | |
def | mysql | PRIMARY | mysql | innodb_index_stats | PRIMARY KEY | YES | |
def | mysql | PRIMARY | mysql | innodb_table_stats | PRIMARY KEY | YES | |
def | mysql | PRIMARY | mysql | password_history | PRIMARY KEY | YES | |
def | mysql | PRIMARY | mysql | plugin | PRIMARY KEY | YES | |
def | mysql | PRIMARY | mysql | procs_priv | PRIMARY KEY | YES | |
def | mysql | PRIMARY | mysql | proxies_priv | PRIMARY KEY | YES | |
def | mysql | PRIMARY | mysql | role_edges | PRIMARY KEY | YES | |
def | mysql | PRIMARY | mysql | server_cost | PRIMARY KEY | YES | |
def | mysql | PRIMARY | mysql | servers | PRIMARY KEY | YES | |
def | mysql | PRIMARY | mysql | slave_master_info | PRIMARY KEY | YES |
|