_View.Delete (gb.mysql)

Sub Delete ( Views As String[] [ , IfExists As Boolean ] )

Supprime une ou plusieurs vues.

View: est un tableau contenant les noms des vues.
IfExists: Admet True ou False, si True est donné, alors "IF EXISTS" est ajouté à la commande.

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.View.Delete(["view_actor"], True)

MySQL statement: DROP VIEW IF EXISTS `view_actor`