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 | atmdb | aeskey_ibfk_1 | def | atmdb | PRIMARY | NONE | NO ACTION | NO ACTION | aeskey | client | |
def | atmdb | card_accountNum_fk | def | atmdb | accountNumber | NONE | NO ACTION | NO ACTION | card | account | |
def | atmdb | tran_accountNum_fk | def | atmdb | accountNumber | NONE | NO ACTION | NO ACTION | transaction | account |
|