# How to Extract Foreign Key Names from SHOW CREATE TABLE

When you run `SHOW CREATE TABLE `bids`;`, you'll see output like this:

```
CREATE TABLE `bids` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `inquiryId` int(11) NOT NULL,
  `supplierId` int(11) NOT NULL,
  ...
  PRIMARY KEY (`id`),
  KEY `some_index` (`inquiryId`),
  CONSTRAINT `bids_ibfk_1` FOREIGN KEY (`inquiryId`) REFERENCES `inquiries` (`id`) ON DELETE CASCADE,
  CONSTRAINT `bids_ibfk_2` FOREIGN KEY (`supplierId`) REFERENCES `suppliers` (`id`) ON DELETE CASCADE,
  UNIQUE KEY `bids_inquiry_id_supplier_id` (`inquiryId`,`supplierId`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
```

## What to Look For:

1. Look for lines starting with `CONSTRAINT`
2. The constraint name is the part between `CONSTRAINT` and `FOREIGN KEY`
3. Common names: `bids_ibfk_1`, `bids_ibfk_2`, `bids_inquiryId_fk`, `bids_supplierId_fk`

## Example:

If you see:
```
CONSTRAINT `bids_ibfk_1` FOREIGN KEY (`inquiryId`) REFERENCES `inquiries` (`id`)
CONSTRAINT `bids_ibfk_2` FOREIGN KEY (`supplierId`) REFERENCES `suppliers` (`id`)
```

Then the constraint names are:
- `bids_ibfk_1`
- `bids_ibfk_2`

## Next Steps:

Once you have the constraint names, drop them:
```sql
ALTER TABLE `bids` DROP FOREIGN KEY `bids_ibfk_1`;
ALTER TABLE `bids` DROP FOREIGN KEY `bids_ibfk_2`;
```

Then drop the unique index:
```sql
ALTER TABLE `bids` DROP INDEX `bids_inquiry_id_supplier_id`;
```