dbRemoveTable {DBI}R Documentation

Remove a table from the database

Description

Executes the sql DROP TABLE name.

Usage

dbRemoveTable(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 indicating success or failure.

See Also

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

Examples

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

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

dbDisconnect(con)

[Package DBI version 0.5-1 Index]