RODBC (version 1.2-2)

sqlTypeInfo: Request Information about DataTypes in an ODBC Database

Description

Request information about datatypes in an ODBC database

Usage

sqlTypeInfo(channel, type = "all", errors = TRUE, as.is = TRUE)

Arguments

channel

connection handle as returned by odbcConnect.

type

The types of columns about which information is requested. Possible values are "all", "char", "varchar", "real", "float", "double", "integer", "smallint", "timestamp".

errors

if TRUE halt and display error, else return -1

as.is

as in sqlGetResults.

Value

• A data frame on success, or character/verbose on error depending on the errors parameter. See sqlGetResults for further details.

Details

sqlTypeInfo attempts to find the types of columns the database supports. Not all ODBC drivers support this. Where it is supported, it is used to decide what column types to create when creating a new table in the database.

See Also

sqlGetResults, odbcGetInfo