SELECT * FROM `TABLE_CONSTRAINTS`
|
CONSTRAINT_CATALOG | CONSTRAINT_SCHEMA | CONSTRAINT_NAME | TABLE_SCHEMA | TABLE_NAME | CONSTRAINT_TYPE | ENFORCED | |
---|---|---|---|---|---|---|---|
def | StdMdDB | PRIMARY | StdMdDB | course | PRIMARY KEY | YES | |
def | StdMdDB | PRIMARY | StdMdDB | student | PRIMARY KEY | YES | |
def | StdMdDB | PRIMARY | StdMdDB | user | PRIMARY KEY | YES | |
def | Stefano | PRIMARY | Stefano | vulcano | PRIMARY KEY | YES | |
def | Table_insertion | PRIMARY | Table_insertion | RK | PRIMARY KEY | YES | |
def | Table_insertion | PRIMARY | Table_insertion | cours | PRIMARY KEY | YES | |
def | Table_insertion | PRIMARY | Table_insertion | ecurie | PRIMARY KEY | YES | |
def | Table_insertion | PRIMARY | Table_insertion | pilote | PRIMARY KEY | YES | |
def | Table_insertion | PRIMARY | Table_insertion | rallye | PRIMARY KEY | YES | |
def | Table_insertion | PRIMARY | Table_insertion | speciale | PRIMARY KEY | YES | |
def | Table_insertion | PRIMARY | Table_insertion | voiture | PRIMARY KEY | YES | |
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 |
|