Learn R Programming

DBI (version 0.5-1)

dbExistsTable: Does a table exist?

Description

Does a table exist?

Usage

dbExistsTable(conn, name, ...)

Arguments

conn
A DBIConnection object, as produced by dbConnect.
name
A character string specifying a DBMS table name.
...
Other parameters passed on to methods.

Value

a logical vector of length 1.

See Also

Other DBIConnection generics: DBIConnection-class, dbDataType, dbDisconnect, dbExecute, dbGetException, dbGetInfo, dbGetQuery, dbIsValid, dbListFields, dbListResults, dbListTables, dbReadTable, dbRemoveTable, dbSendQuery, dbSendStatement

Examples

Run this code
con <- dbConnect(RSQLite::SQLite(), ":memory:")

dbExistsTable(con, "iris")
dbWriteTable(con, "iris", iris)
dbExistsTable(con, "iris")

dbDisconnect(con)

Run the code above in your browser using DataLab