How do you tell if a particular database table has already been created?

[rleiman]

Hi Everyone,

How do you tell if a particular database table has already been created?

I would only like to execute this code if the table is not there yet:

   ' Create the VisitResults table which holds lookup data about each visit.
   '------------------------------------------------------------------------
   Dim mapOfDatabaseTable As Map
   mapOfDatabaseTable.Initialize
   mapOfDatabaseTable.Put("Id", DBUtils.DB_TEXT)
   mapOfDatabaseTable.Put("ResultDescription", DBUtils.DB_TEXT)
   DBUtils.CreateTable(SQL, "ResultDescription", mapOfDatabaseTable, "Id")

 

[Erel]

if SQL.ExecQuerySingleResult("SELECT count(name) FROM sqlite_master WHERE type='table' AND name='ResultDescription'") = 0 Then
'Create table
End if

 

[rleiman]

Hi Erel,

Thanks.