Deleting an index
Michael Fernandez 3 years ago • updated by Support 3 years ago • 4
I accidentally created an index on a table but I can't figure out how to delete it. After clicking on this table in my diagram, in table properties there is an indexes & keys section which allows me to create another key. However, the delete option is not clickable and not colored in. How can I use this option?
Customer support service by UserEcho
I think the issue is regarding selected the index but not opening index details/properties. Anyways, we will work on this issue soon, and resolve it.
For now, the trick is click on the right corner of the index row (as show in following screenshot at number 2). When the index is selected, you can click on delete icon to delete it.
Please feel free to contact us in case you still facing issue with it.
Team - SqlDBM
This issue still seems to not have been fixed. I appreciate that you can do the workaround and delete the column but I would rather not have to delete the column. This was reported 4 months ago and has still not been fixed.
We are reviewing the product as a potential large corporate purchase and it would be good to see basic issues such as this being fixed. When are you likely to fix it please?
And as a follow up to this, even if you delete the column with the index, the index still remains in the 'Indexes and Keys' list.
I think there is misunderstanding. We did not recommend to delete the column, but instead we provided a way to delete the index only.
Current problem is on how to select the index to delete and the solution is:
- Click on far right side of the Index row which you want to delete, this lets "Index Selection" & makes it highlighted as blue
- now click on "Delete" icon to delete it
Please lLet us know if you still have issues with it.
FYI: We are working on this issue with our team for easy index selected to perform delete action.
Team - SqlDBM