-- Find foreign key constraint names - CORRECTED VERSION
-- Run this complete query:

SELECT 
    rc.CONSTRAINT_NAME,
    kcu.COLUMN_NAME,
    kcu.REFERENCED_TABLE_NAME,
    kcu.REFERENCED_COLUMN_NAME
FROM INFORMATION_SCHEMA.REFERENTIAL_CONSTRAINTS rc
JOIN INFORMATION_SCHEMA.KEY_COLUMN_USAGE kcu 
    ON rc.CONSTRAINT_NAME = kcu.CONSTRAINT_NAME 
    AND rc.CONSTRAINT_SCHEMA = kcu.CONSTRAINT_SCHEMA
WHERE rc.CONSTRAINT_SCHEMA = DATABASE()
  AND rc.TABLE_NAME = 'bids'
ORDER BY rc.CONSTRAINT_NAME, kcu.ORDINAL_POSITION;

-- This will show you the exact CONSTRAINT_NAME values
-- Use those names in: ALTER TABLE `bids` DROP FOREIGN KEY `CONSTRAINT_NAME`;

