Remove a remote table (e.g., created by
from the database.
A DBIConnection object, as returned by
A character string specifying a DBMS table name.
Other parameters passed on to methods.
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
name cannot be processed with
or if this results in a non-scalar.
The following arguments are not part of the
(to improve compatibility across backends)
but are part of the DBI specification:
These arguments must be provided as named arguments.
TRUE, the call to
will consider only temporary tables.
Not all backends support this argument.
In particular, permanent tables of the same name are left untouched.
FALSE, the call to
succeeds if the table does not exist.
A table removed by
dbRemoveTable() doesn't appear in the list of tables
The removal propagates immediately to other connections to the same database.
This function can also be used to remove a temporary table.
name argument is processed as follows,
to support databases that allow non-syntactic names for their objects:
If an unquoted table name as string:
dbRemoveTable() will do the
perhaps by calling
dbQuoteIdentifier(conn, x = name)
If the result of a call to
dbQuoteIdentifier(): no more quoting is done
Other DBIConnection generics:
1 2 3 4 5 6 7 8 9
Add the following code to your website.
For more information on customizing the embed code, read Embedding Snippets.