1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
|
\name{sqlTypeInfo}
\alias{sqlTypeInfo}
\title{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{
\item{channel}{connection handle as returned by
\code{\link{odbcConnect}}.}
\item{type}{The types of columns about which information is
requested. Possible values are \code{"all", "char", "varchar", "real",
"float", "double", "integer", "smallint", "timestamp"}.}
\item{errors}{if TRUE halt and display error, else return -1}
\item{as.is}{as in \code{\link{sqlGetResults}}.}
}
\details{
\code{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.
}
\value{
A data frame on success, or character/verbose
on error depending on the \code{errors} parameter. See
\code{\link{sqlGetResults}} for further details.
}
\seealso{
\code{\link{sqlGetResults}}, \code{\link{odbcGetInfo}}
}
\author{
Brian Ripley
}
\keyword{IO}
\keyword{database}
|
