_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`