-- Find the exact foreign key constraint names
-- Run this query to see all foreign keys on the bids table:

SELECT 
    CONSTRAINT_NAME,
    COLUMN_NAME,
    REFERENCED_TABLE_NAME,
    REFERENCED_COLUMN_NAME
FROM INFORMATION_SCHEMA.KEY_COLUMN_USAGE
WHERE TABLE_SCHEMA = DATABASE()
  AND TABLE_NAME = 'bids'
  AND REFERENCED_TABLE_NAME IS NOT NULL
ORDER BY CONSTRAINT_NAME, ORDINAL_POSITION;

-- This will show you the exact CONSTRAINT_NAME values
-- Use those names in the DROP FOREIGN KEY commands

-- Also run this to see the table structure:
SHOW CREATE TABLE `bids`;

-- The output will show the exact foreign key names in the CREATE TABLE statement

