R/DBI.R
dbRemoveTable-DatabaseConnectorConnection-character-method.Rd
Remove a remote table (e.g., created by dbWriteTable()
)
from the database.
# S4 method for DatabaseConnectorConnection,character
dbRemoveTable(
conn,
name,
database = NULL,
schema = NULL,
oracleTempSchema = NULL,
tempEmulationSchema = getOption("sqlRenderTempEmulationSchema"),
...
)
A DBIConnection object, as returned by
dbConnect()
.
A character string specifying a DBMS table name.
Name of the database.
Name of the schema.
DEPRECATED: use tempEmulationSchema
instead.
Some database platforms like Oracle and Impala do not truly support temp tables. To emulate temp tables, provide a schema with write privileges where temp tables can be created.
Other parameters passed on to methods.
dbRemoveTable()
returns TRUE
, invisibly.
If the table does not exist, an error is raised.
An attempt to remove a view with this function may result in an error.
An error is raised when calling this method for a closed
or invalid connection.
An error is also raised
if name
cannot be processed with dbQuoteIdentifier()
or if this results in a non-scalar.
Other DBIConnection generics:
DBIConnection-class
,
dbAppendTable()
,
dbCreateTable()
,
dbDataType()
,
dbDisconnect()
,
dbExecute()
,
dbExistsTable()
,
dbGetException()
,
dbGetInfo()
,
dbGetQuery()
,
dbIsReadOnly()
,
dbIsValid()
,
dbListFields()
,
dbListObjects()
,
dbListResults()
,
dbListTables()
,
dbReadTable()
,
dbSendQuery()
,
dbSendStatement()
,
dbWriteTable()