dbListTables {DBI} | R Documentation |
List remote tables, fields of a remote table, opened connections and pending statements in a connection.
dbListTables(conn, ...) dbListFields(conn, name, ...) dbListConnections(drv, ...) dbListResults(conn, ...)
drv |
a driver object (e.g., ODBC , Oracle ) |
conn |
a connection object |
name |
a character string with the name of the remote table. |
... |
optional arguments for the actual driver implementation. |
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.
See the Database Interface definition document
DBI.pdf
in the base directory of this package
or
http://developer.r-project.org/db.
dbGetInfo
,
dbColumnInfo
,
dbDriver
,
dbConnect
,
dbSendQuery
## Not run: odbc <- dbDriver("ODBC") # after working awhile... for(con in dbListConnections(odbc)){ dbGetStatement(dbListResults(con)) } ## End(Not run)