sqliteTableExists: Check if a table exists in the database

In kevinrue/sqlighter: Wrappers and extensions to the RSQLite package

Description

Check if a table exists in the database

Usage

sqliteTableExists(table, file)

Arguments

table	Name of the table to check for existence
file	Database to query

Value

A logical value that indicates whether the table exists in the database.

Examples

# Example data ----
library(RSQLite)

database_file <- tempfile()
conn <- dbConnect(SQLite(), dbname = database_file)
dbWriteTable(conn, "mtcars", mtcars[1:5, ])
dbWriteTable(conn, "USArrests", USArrests[1:5, ])
dbDisconnect(conn)


# Example ----

sqliteTableExists("status_summary", database_file)

kevinrue/sqlighter documentation built on Nov. 16, 2020, 5:59 p.m.