Remove a table from the database
Source:R/DBI.R
dbRemoveTable-DatabaseConnectorConnection-ANY-method.RdRemove a remote table (e.g., created by dbWriteTable())
from the database.
# S4 method for class 'DatabaseConnectorConnection,ANY'
dbRemoveTable(conn, name, databaseSchema = NULL, ...)Arguments
- conn
A DBIConnection object, as returned by
dbConnect().- name
The table name, passed on to
dbQuoteIdentifier(). Options are:a character string with the unquoted DBMS table name, e.g.
"table_name",a call to
Id()with components to the fully qualified table name, e.g.Id(schema = "my_schema", table = "table_name")a call to
SQL()with the quoted and fully qualified table name given verbatim, e.g.SQL('"my_schema"."table_name"')
- databaseSchema
The name of the database schema. See details for platform-specific details.
- ...
Other parameters passed on to methods.
Value
dbRemoveTable() returns TRUE, invisibly.
Details
The databaseSchema argument is interpreted differently according to the different platforms:
SQL Server and PDW: The databaseSchema schema should specify both the database and the schema, e.g.
'my_database.dbo'. Impala: the databaseSchema should specify the database. Oracle:
The databaseSchema should specify the Oracle 'user'. All other : The databaseSchema should
specify the schema.
See also
Other DBIConnection generics:
DBIConnection-class,
dbAppendTable(),
dbAppendTableArrow(),
dbCreateTable(),
dbCreateTableArrow(),
dbDataType(),
dbDisconnect(),
dbExecute(),
dbExistsTable(),
dbGetException(),
dbGetInfo(),
dbGetQuery(),
dbGetQueryArrow(),
dbIsReadOnly(),
dbIsValid(),
dbListFields(),
dbListObjects(),
dbListResults(),
dbListTables(),
dbQuoteIdentifier(),
dbReadTable(),
dbReadTableArrow(),
dbSendQuery(),
dbSendQueryArrow(),
dbSendStatement(),
dbUnquoteIdentifier(),
dbWriteTable(),
dbWriteTableArrow()