Function reference • odbc

DBI methods

odbc() dbConnect(<OdbcDriver>): Connect to a database via an ODBC driver

dbListTables(<OdbcConnection>) dbListFields(<OdbcConnection>,<character>): List remote tables and fields for an ODBC connection

dbWriteTable(<OdbcConnection>,<character>,<data.frame>) dbWriteTable(<OdbcConnection>,<Id>,<data.frame>) dbWriteTable(<OdbcConnection>,<SQL>,<data.frame>) dbAppendTable(<OdbcConnection>) sqlCreateTable(<OdbcConnection>): Convenience functions for reading/writing DBMS tables

Database-specific helpers

databricks() dbConnect(<DatabricksOdbcDriver>): Helper for Connecting to Databricks via ODBC

Microsoft SQL Server-class dbUnquoteIdentifier,Microsoft SQL Server,SQL-method isTempTable,Microsoft SQL Server,character-method isTempTable,Microsoft SQL Server,SQL-method dbExistsTable,Microsoft SQL Server,character-method dbListTables,Microsoft SQL Server-method dbExistsTable,Microsoft SQL Server,Id-method dbExistsTable,Microsoft SQL Server,SQL-method odbcConnectionSchemas,Microsoft SQL Server-method sqlCreateTable,Microsoft SQL Server-method: SQL Server

sqlCreateTable(<Oracle>) odbcConnectionTables(<Oracle>,<character>): Oracle

ODBC configuration

odbc() dbConnect(<OdbcDriver>): Connect to a database via an ODBC driver

odbcDataType(): Return the corresponding ODBC data type for an R object

odbcListColumns(): List columns in an object.

odbcListConfig(): List locations of ODBC configuration files

odbcListDataSources(): List Configured Data Source Names

odbcListDrivers(): List Configured ODBC Drivers

odbcListObjectTypes(): Return the object hierarchy supported by a connection.

odbcListObjects(): List objects in a connection.

odbcPreviewObject(): Preview the data in an object.

odbcSetTransactionIsolationLevel(): Set the Transaction Isolation Level for a Connection

isTempTable(): Helper method used to determine if a table identifier is that of a temporary table.

quote_value(): Quote special character when connecting