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!
All 4 Replies
Be a part of the DaniWeb community
We're a friendly, industry-focused community of 1.21 million developers, IT pros, digital marketers, and technology enthusiasts learning and sharing knowledge.