List table names in an SQLite database

List table names in an SQLite database

sqliteListTables(file)

Arguments

file	Path to the SQLite database file

Value

A character vector of table names.

Examples

# 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)
#> [1] "USArrests" "mtcars"