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
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.