DBI-package R Database Interface DBIConnection-class DBIConnection class DBIDriver-class DBIDriver class DBIObject-class DBIObject class DBIResult-class DBIResult class DBIspec DBI specification SQL SQL quoting Table-class Refer to a table nested in a hierarchy (e.g. within a schema) dbBind Bind values to a parameterised/prepared statement dbClearResult Clear a result set dbColumnInfo Information about result types dbConnect Create a connection to a DBMS dbDataType Determine the SQL data type of an object dbDisconnect Disconnect (close) a connection dbDriver Load and unload database drivers dbExecute Execute an update statement, query number of rows affected, and then close result set dbExistsTable Does a table exist? dbFetch Fetch records from a previously executed query dbGetException Get DBMS exceptions dbGetInfo Get DBMS metadata dbGetQuery Send query, retrieve results and then clear result set dbGetRowCount The number of rows fetched so far dbGetRowsAffected The number of rows affected dbGetStatement Get the statement associated with a result set dbHasCompleted Completion status dbIsValid Is this DBMS object still valid? dbListConnections List currently open connections dbListFields List field names of a remote table dbListResults A list of all pending results dbListTables List remote tables dbReadTable Copy data frames to and from database tables dbRemoveTable Remove a table from the database dbSendQuery Execute a query on a given database connection dbSendStatement Execute a data manipulation statement on a given database connection dbWithTransaction Self-contained SQL transactions make.db.names Make R identifiers into legal SQL identifiers rownames Convert row names back and forth between columns sqlAppendTable Insert rows into a table sqlCreateTable Create a simple table sqlData Convert a data frame into form suitable for upload to a SQL database sqlInterpolate Safely interpolate values into an SQL string transactions Begin/commit/rollback SQL transactions