dbExistsTable: dbExistsTable()

In kineticadb/RKinetica: Kinetica DBI datasource

Description

Checks if the table exists. Provide either table name or collection name, not both Kinetica DB table names are unique, different collections don't allow tables with the same name.

Usage

dbExistsTable(conn, name, ...)

Arguments

conn	an object of [KineticaConnection-class]
name	character string for table or collection name or [KineticaId-class] object
...	Other parameters passed on to methods.

Value

logical

See Also

Other KineticaConnection methods: dbAppendTable, dbCreateTable, dbDataType,KineticaConnection-method, dbDisconnect,KineticaConnection-method, dbExecute,KineticaConnection,character-method, dbGetInfo, dbGetQuery,KineticaConnection,character-method, dbIsValid, dbListFields, dbListObjects,KineticaConnection-method, dbListResults,KineticaConnection-method, dbListTables,KineticaConnection-method, dbReadTable, dbRemoveTable, dbSendQuery,KineticaConnection,character-method, dbSendStatement,KineticaConnection,character-method, dbWriteTable, show,KineticaDriver-method, sqlCreateTable,KineticaConnection-method, transactions

Examples

## Not run: 
con <- dbConnect(Kinetica(), url = "http://localhost:9191")
dbCreateTable(con, "tableA", data.frame(a = 1))
dbExistsTable(con, "tableA")
# TRUE
dbExecute(con, "DROP TABLE tableA")
# 1
dbExistsTable(con, "tableA")
# FALSE
dbDisconnect(con)

## End(Not run)

kineticadb/RKinetica documentation built on Sept. 29, 2020, 5:38 p.m.