jdbcTypeInfo
Retrieve Supported Column Type Info from a Database

### Description

Retrieves a table containing the data types supported by the connected database.

### Usage

    jdbcTypeInfo(driverClass, con, user, password, keepAlive)

### Arguments

driverClass | a string specifying the name of the Java class for the required JDBC driver.
con | the JDBC connection string.
user | a string specifying the user name with access to the database.
password | a string containing the password for given the user name on the database.
keepAlive | a logical. If TRUE, keeps the database connection alive after executing the query. The default is FALSE.

### Details

A direct interface to the java.sql.DatabaseMetaData.getTypeInfo() method. See the Java documentation for description of the fields in the table. Useful for debugging.
Value
returns a data.frame containing the entire table.
References
2004. http://java.sun.com/j2se/1.5.0/docs/api/java/sql/DatabaseMetaData.html#getTypeInfo(). Java SE Developer Documentation. Redwood Shores, CA: Oracle Corporation.
Examples

    ## Not run:
    jdbcTypeInfo(driverClass="com.microsoft.sqlserver.jdbc.SQLServerDriver",
                con="jdbc:sqlserver://qadb-s2k:1433;databaseName=testdb;user=testqa;password=testqa;",
                user="testqa", password="testqa")

    ## End(Not run)

Package sjdbc version 6.1.5-18
Package Index