SELECT * FROM `REFERENTIAL_CONSTRAINTS`
|
CONSTRAINT_CATALOG | CONSTRAINT_SCHEMA | CONSTRAINT_NAME | UNIQUE_CONSTRAINT_CATALOG | UNIQUE_CONSTRAINT_SCHEMA | UNIQUE_CONSTRAINT_NAME | MATCH_OPTION | UPDATE_RULE | DELETE_RULE | TABLE_NAME | REFERENCED_TABLE_NAME | |
---|---|---|---|---|---|---|---|---|---|---|---|
def | STB | Employes_ibfk_1 | def | STB | PRIMARY | NONE | NO ACTION | SET NULL | Employes | Agences | |
def | STB | Comptes_ibfk_1 | def | STB | PRIMARY | NONE | NO ACTION | CASCADE | Comptes | Clients | |
def | STB | Prets_ibfk_1 | def | STB | PRIMARY | NONE | NO ACTION | CASCADE | Prets | Clients | |
def | STB | Transactions_ibfk_1 | def | STB | PRIMARY | NONE | NO ACTION | CASCADE | Transactions | Comptes |
|