The primary key wil not be deleted. How dos it come that dbForge can delete the primary key succesfully? My emloyer wants to know.Incorrect table definition; there can be only one auto column and it must be defined as a key
studio better than other tools.
studio better than other tools.
dbForge works great. I even can delete a primary key without problems. Other applications like Toad for MySQL, MySQL browser and Maestro for MySQL wil give this error message:
It looks like a problem with autoincrement column and it depends on table structure.
But if you want to know what SQL produces our product to alter the table do following:
1. Go to Tools->Options->Environment->Output
2. Check Schema Object Editor' option in SQL Log category
3. Open SQL Log tab in Output window
4. Modify and save table and see what SQL statement it sends to server
But if you want to know what SQL produces our product to alter the table do following:
1. Go to Tools->Options->Environment->Output
2. Check Schema Object Editor' option in SQL Log category
3. Open SQL Log tab in Output window
4. Modify and save table and see what SQL statement it sends to server