Determine the SQL data type of an object — dbDataType

Returns an SQL string that describes the SQL data type to be used for an object. The default implementation of this generic determines the SQL type of an R object according to the SQL 92 specification, which may serve as a starting point for driver implementations. DBI also provides an implementation for data.frame which will return a character vector giving the type for each column in the dataframe. Methods in other packagesThis documentation page describes the generics. Refer to the documentation pages linked below for the documentation for the methods that are implemented in various backend packages. adbi::dbDataType("AdbiConnection", "ANY") adbi::dbDataType("AdbiDriver", "ANY") bigrquery::dbDataType("BigQueryConnection", "ANY") bigrquery::dbDataType("BigQueryDriver", "ANY") duckdb::dbDataType("duckdb_connection", "ANY") duckdb::dbDataType("duckdb_driver", "ANY") lazysf::dbDataType("SFSQLDriver", "ANY") odbc::dbDataType("OdbcConnection", "ANY") odbc::dbDataType("OdbcConnection", "data.frame") odbc::dbDataType("OdbcDriver", "ANY") odbc::dbDataType("OdbcDriver", "data.frame") odbc::dbDataType("OdbcDriver", "list") pool::dbDataType("Pool", "ANY") RAthena::dbDataType("AthenaConnection", "ANY") RAthena::dbDataType("AthenaConnection", "data.frame") RAthena::dbDataType("AthenaDriver", "ANY") RAthena::dbDataType("AthenaDriver", "list") RH2::dbDataType("H2Connection", "ANY") RJDBC::dbDataType("JDBCConnection", "ANY") RMariaDB::dbDataType("MariaDBConnection", "ANY") RMariaDB::dbDataType("MariaDBDriver", "ANY") RMySQL::dbDataType("MySQLConnection", "ANY") RMySQL::dbDataType("MySQLDriver", "ANY") RPostgres::dbDataType("PqConnection", "ANY") RPostgres::dbDataType("PqDriver", "ANY") RPostgreSQL::dbDataType("PostgreSQLObject", "ANY") RPresto::dbDataType("PrestoDriver", "ANY") RSQLite::dbDataType("SQLiteConnection", "ANY") RSQLite::dbDataType("SQLiteDriver", "ANY") sergeant::dbDataType("DrillConnection", "ANY") sf::dbDataType("DBIObject", "sf") sf::dbDataType("PostgreSQLConnection", "sf") sparklyr::dbDataType("spark_connection", "ANY")