sqliteListTables: List table names in an SQLite database

Description Usage Arguments Value Examples

View source: R/rsqlite.R

Description

List table names in an SQLite database

Usage

1

Arguments

file

Path to the SQLite database file

Value

A character vector of table names.

Examples

 1
 2
 3
 4
 5
 6
 7
 8
 9
10
11
12
# Setup ----
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 ----

sqliteListTables(database_file)

kevinrue/sqliter documentation built on Nov. 17, 2020, 7:10 a.m.