| dbListFields {DBI} | R Documentation |
List field names of a remote table
dbListFields(conn, name, ...)
conn |
A DBIConnection object, as returned by
|
name |
a character string with the name of the remote table. |
... |
Other parameters passed on to methods. |
a character vector
dbColumnInfo() to get the type of the fields.
Other DBIConnection generics: DBIConnection-class,
dbDataType, dbDisconnect,
dbExecute, dbExistsTable,
dbGetException, dbGetInfo,
dbGetQuery, dbIsValid,
dbListResults, dbListTables,
dbReadTable, dbRemoveTable,
dbSendQuery, dbSendStatement,
dbWriteTable
con <- dbConnect(RSQLite::SQLite(), ":memory:") dbWriteTable(con, "mtcars", mtcars) dbListFields(con, "mtcars") dbDisconnect(con)