Home / comp / gb.db.mysql / _index / delete 
Previous  Next  Edit  Rename  Undo  Refresh  Search  Administration   
fr  de  es  it  nl  pl  pt  pt_BR  mk  sq  ca  ar  fa  vi  ja  ru  zh  zh_TW  eo 
Documentation
History
 
Delete
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`