dbRemoveTable

0th

Percentile

Remove a table from the database

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

Aliases
  • dbRemoveTable
Examples
library(DBI) con <- dbConnect(RSQLite::SQLite(), ":memory:") dbExistsTable(con, "iris") dbWriteTable(con, "iris", iris) dbExistsTable(con, "iris") dbRemoveTable(con, "iris") dbExistsTable(con, "iris") dbDisconnect(con)
Documentation reproduced from package DBI, version 0.5-1, License: LGPL (>= 2)

Community examples

Looks like there are no examples yet.