DROP INDEXindex_nameONtbl_name
      DROP INDEX drops the index named
      index_name from the table
      tbl_name. In MySQL 3.22 or later,
      DROP INDEX is mapped to an
      ALTER TABLE statement to drop the
      index. See Section 12.1.2, “ALTER TABLE Syntax”.
      DROP INDEX does not do anything
      prior to MySQL 3.22.
    


User Comments
Add your own comment.