jdbcTypeInfo: Retrieve Supported Column Type Info from a Database

In sjdbc: JDBC Driver Interface

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. https://docs.oracle.com/javase/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)

sjdbc documentation built on May 1, 2021, 1:08 a.m.