Hello, I can not delete the column index from the database

I tried to add it and delete it - it is deleted, but the gray key icon does not disappear

enter image description here

  • and if so ALTER TABLE users DROP INDEX user; - Alexey Shimansky
  • unfortunately does not help - turik97
  • user and such an index exists in your table? As I see the user - the column name, but not the index! - Bohdan Korinnyi
  • as you can see near the users column there is a gray key icon, and its title is = "Index" - turik97
  • And what does the "show indexes in users" command give? - Alexus

1 answer 1

In PHPMyAdmin on the left, where all the tables are listed, there is a plus sign. You open it, there is a field "Indices". Try to remove it from there.

  • there is no this field - turik97
  • vk.com/doc245028753_441617067 You choose the structure of the table. Below the table there is a tab indexes. You open it, you see all the indexes on the table. To delete just click the cross. - Dmitriy