dbDisconnect {DBI} | R Documentation |
Disconnect (close) a connection
Description
This closes the connection, discards all pending work, and frees resources (e.g., memory, sockets).
Usage
dbDisconnect(conn, ...)
Arguments
conn |
A DBIConnection object, as returned by
|
... |
Other parameters passed on to methods. |
Value
dbDisconnect()
returns TRUE
, invisibly.
Failure modes
A warning is issued on garbage collection when a connection has been
released without calling dbDisconnect()
,
but this cannot be tested automatically.
At least one warning is issued immediately when calling dbDisconnect()
on an
already disconnected
or invalid connection.
See Also
Other DBIConnection generics:
DBIConnection-class
,
dbAppendTable()
,
dbAppendTableArrow()
,
dbCreateTable()
,
dbCreateTableArrow()
,
dbDataType()
,
dbExecute()
,
dbExistsTable()
,
dbGetException()
,
dbGetInfo()
,
dbGetQuery()
,
dbGetQueryArrow()
,
dbIsReadOnly()
,
dbIsValid()
,
dbListFields()
,
dbListObjects()
,
dbListResults()
,
dbListTables()
,
dbQuoteIdentifier()
,
dbReadTable()
,
dbReadTableArrow()
,
dbRemoveTable()
,
dbSendQuery()
,
dbSendQueryArrow()
,
dbSendStatement()
,
dbUnquoteIdentifier()
,
dbWriteTable()
,
dbWriteTableArrow()
Examples
con <- dbConnect(RSQLite::SQLite(), ":memory:")
dbDisconnect(con)