RSQLite (version 1.0.0)

dbGetInfo: Get metadata about a database object.

Description

Get metadata about a database object.

Usage

# S4 method for SQLiteDriver
dbGetInfo(dbObj)
# S4 method for SQLiteConnection
dbGetInfo(dbObj)
# S4 method for SQLiteResult
dbGetInfo(dbObj)

Arguments

dbObj

An object of class '>SQLiteDriver, '>SQLiteConnection or '>SQLiteResult

Examples

# NOT RUN {
dbGetInfo(SQLite())

con <- dbConnect(SQLite())
dbGetInfo(con)

dbWriteTable(con, "mtcars", mtcars)
rs <- dbSendQuery(con, "SELECT * FROM mtcars")
dbGetInfo(rs)
dbFetch(rs, 1)
dbGetInfo(rs)

dbClearResult(rs)
dbDisconnect(con)
# }