外部キーやユニークキーなどが貼られているか確認

MySQL

show create table

で確認できる 

mysql> show create table hoge;
+---

| hoge | CREATE TABLE `hoge` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `fuga_id` int(10) unsigned NOT NULL,
  `piyo_id` int(10) unsigned NOT NULL,
  `created_at` datetime NOT NULL,
  `updated_at` datetime NOT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `xxx_idx` (`fuga_id`,`piyo_id`),
  KEY `hoge_fuga` (`fuga_id`),
  KEY `hoge_piyo` (`piyo_id`),
  CONSTRAINT `hoge_id_fuga_id` FOREIGN KEY (`fuga_id`) REFERENCES `fuga` (`id`) ON DELETE CASCADE,
  CONSTRAINT `hoge_id_piyo_id` FOREIGN KEY (`piyo_id`) REFERENCES `piyo` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci |