| sqlTypeInfo {RODBC} | R Documentation |
Request information about datatypes in an ODBC database
sqlTypeInfo(channel, type = "all", errors = TRUE, as.is = TRUE)
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. |
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.
A data frame on success, or character/verbose
on error depending on the errors parameter. See
sqlGetResults for further details.
Brian Ripley