Learn R Programming

DBI (version 0.5-1)

dbListFields: List field names of a remote table

Description

List field names of a remote table

Usage

dbListFields(conn, name, ...)

Arguments

conn
A DBIConnection object, as produced by dbConnect.
name
a character string with the name of the remote table.
...
Other parameters passed on to methods.

Value

a character vector

See Also

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

Examples

Run this code
con <- dbConnect(RSQLite::SQLite(), ":memory:")

dbWriteTable(con, "mtcars", mtcars)
dbListFields(con, "mtcars")

dbDisconnect(con)

Run the code above in your browser using DataLab