_Index.Delete (gb.mysql)

Sub Delete ( Table As String, Index As String [ , Database As String ] )

Supprime l'index à partir d'une table.

Table: Est le nom de la table.
Index: Est le nom de l'index.

Exemples

Dim hCon As New Connection

With hCon
  .Type = "mysql"
  .Port = "3306"
  .Host = "localhost"
  .User = "root"
  .Password = "mypass"
  .Name = "Gambas"
  .Open()
End With

hCon.MySQL.Index.Delete("actor", "idx_actor_id")

Commande MySQL : DROP INDEX `idx_actor_id` ON `actor`