RSQLite (version 1.1-1)

dbRemoveTable,SQLiteConnection,character-method: Remove a table from the database

Description

Executes the SQL DROP TABLE.

Usage

# S4 method for SQLiteConnection,character
dbRemoveTable(conn, name, ...)

Arguments

conn

An existing '>SQLiteConnection

name

character vector of length 1 giving name of table to remove

...

Needed for compatibility with generic. Otherwise ignored.

See Also

The corresponding generic function DBI::dbRemoveTable().

Examples

Run this code
# NOT RUN {
library(DBI)
con <- dbConnect(RSQLite::SQLite())
dbWriteTable(con, "test", data.frame(a = 1))
dbListTables(con)
dbRemoveTable(con, "test")
dbListTables(con)
dbDisconnect(con)
# }

Run the code above in your browser using DataCamp Workspace