sqlTypeInfo: Request Information about Data Types in an ODBC Database

Description Usage Arguments Details Value Author(s) See Also Examples

View source: R/TypeInfo.R

Description

Request information about data types in an ODBC database

Usage

1
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" , "wchar", "wvarchar" (Unicode), "real", "float", "double", "integer", "smallint", "date", "time", "timestamp", "binary", "varbinary", "longvarbinary" and (its alias) "blob".

errors

logical: if true halt and display error, else return -1.

as.is

as in sqlGetResults.

Details

sqlTypeInfo attempts to find the types of columns the database supports: ODBC drivers are not required to support this (but all known examples do). Where it is supported, it is used by sqlSave to decide what column types to create when creating a new table in the database.

Value

A data frame on success, or character/numeric on error depending on the errors argument. Use sqlGetResults for further details of errors.

The columns returned may depend on the ODBC driver manager. For a fully ODBC 3 manager, see https://docs.microsoft.com/en-us/sql/odbc/reference/syntax/sqlgettypeinfo-function?view=sql-server-ver15 the symbolic constants mentioned there will be returned as numbers (and the values of the numeric constants can be found in the ODBC headers such as ‘sql.h’ and ‘sqlext.h’).

Author(s)

Brian Ripley

See Also

sqlGetResults, odbcGetInfo

Examples

 1
 2
 3
 4
 5
 6
 7
 8
 9
10
11
## Not run: 
> names(sqlTypeInfo(channel))
 [1] "TYPE_NAME"          "DATA_TYPE"          "COLUMN_SIZE"       
 [4] "LITERAL_PREFIX"     "LITERAL_SUFFIX"     "CREATE_PARAMS"     
 [7] "NULLABLE"           "CASE_SENSITIVE"     "SEARCHABLE"        
[10] "UNSIGNED_ATTRIBUTE" "FIXED_PREC_SCALE"   "AUTO_UNIQUE_VALUE" 
[13] "LOCAL_TYPE_NAME"    "MINIMUM_SCALE"      "MAXIMUM_SCALE"     
[16] "SQL_DATATYPE"       "SQL_DATETIME_SUB"   "NUM_PREC_RADIX"    
[19] "INTERVAL_PRECISION"

## End(Not run)

RODBC documentation built on Sept. 17, 2021, 1:06 a.m.