我是cascades的新手,我刚做了类似以下的操作:
CREATE TABLE IF NOT EXISTS `test_deck_link_2`(
`id` INTEGER NOT NULL AUTO_INCREMENT PRIMARY KEY,
`deck_id` INTEGER NOT NULL,
FOREIGN KEY (deck_id) REFERENCES test_deck (id)
ON DELETE CASCADE
ON UPDATE CASCADE
)
ENGINE=InnoDB
DEFAULT CHARSET=utf8;
INSERT INTO decks (user_id,header)VALUES(1,"foo");
ALTER TABLE deck_ratings
ADD CONSTRAINT `deck_rating_contraint`
FOREIGN KEY (`deck_id` )
REFERENCES `decks` (`deck_id` )
ON DELETE CASCADE
我该如何在数据库中查看这些信息?目前,我只能看到行的结构,但无法看到它们上面的外键或级联关系。