Gambas Documentation - /comp/gb.mysql/_index/delete

/comp/gb.mysql/_index/delete

# _Index.Delete (gb.mysql)

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

Drops an index from a table.

Table: Is the table name.
Index: Is the index name.

### Examples

    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")

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