REFERENTIAL_CONSTRAINTS

mmt
FieldTypeNullKeyDefaultExtra
CONSTRAINT_CATALOG varchar(64) NO
CONSTRAINT_SCHEMA varchar(64) NO
CONSTRAINT_NAME varchar(64) NO
UNIQUE_CONSTRAINT_CATALOG varchar(64) NO
UNIQUE_CONSTRAINT_SCHEMA varchar(64) NO
UNIQUE_CONSTRAINT_NAME varchar(64) YES
MATCH_OPTION enum('NONE','PARTIAL','FULL') NO
UPDATE_RULE enum('NO ACTION','RESTRICT','CASCADE','SET NULL','SET DEFAULT') NO
DELETE_RULE enum('NO ACTION','RESTRICT','CASCADE','SET NULL','SET DEFAULT') NO
TABLE_NAME varchar(64) NO
REFERENCED_TABLE_NAME varchar(64) NO

[ START ][ Connect ] [ create table form ]

MySQL Nippon Association