Question · SQL and MySQL course · Module 9: Indexes and normalization

Dropping an index

Which command correctly drops the idx_tytul index from the ksiazki table?

Answer options

  • DROP INDEX idx_tytul ON ksiazki;
  • DELETE INDEX idx_tytul FROM ksiazki;
  • REMOVE idx_tytul ON ksiazki;
  • DROP idx_tytul INDEX ksiazki;

You can check the correct answer by solving this task in the CodeWorlds game.