dbListTables(conn, ...)
dbListFields(conn, name, ...)
dbListConnections(drv, ...)
dbListResults(conn, ...)
ODBC
, Oracle
)dbListTables
returns a character vector with the names of the
tables in the remote database associated with the connection in
conn
object. dbListFields
returns a character vector with the names of the
fields of the res
result object (it must be a query statement).
dbListConnections
returns a list of all currently open
connections on driver drv
. Drivers that implement single
connections would return the one single connection object.
dbListResults
returns a list of objects for all pending results
(statements) on the conn
connection.
DBI.pdf
in the base directory of this package
or
dbGetInfo
,
dbColumnInfo
,
dbDriver
,
dbConnect
,
dbSendQuery
odbc <- dbDriver("ODBC")
# after working awhile...
for(con in dbListConnections(odbc)){
dbGetStatement(dbListResults(con))
}
Run the code above in your browser using DataLab