I have two tables.Each has an identical field titled vin. In both tables I've removed all primary keys. I've gone to the relationship view and made sure nothing was selected under the dropdown for foreign key. I've gone to the database designer view, and there are no relationships being shown between any tables. Despite all this, I still get #1553 - Cannot drop index 'vin': needed in a foreign key constraint when I try to drop the index from either table. Thanks for any help!
trbograndnat
2
Newbie Poster
Recommended Answers
Jump to Post`Special Info` text,
`debtor_ID` int(11) NOT NULL,
KEY `vin` (`vin`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;Check at that red, what kind of key it is?
All 4 Replies
devindamenuka
0
Light Poster
trbograndnat
2
Newbie Poster
devindamenuka
0
Light Poster
Stefano Mtangoo
455
Senior Poster
Be a part of the DaniWeb community
We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.