MSSQL (version 1.0.1)

tableOverview: Data Types and Dimensions

Description

Show data types and dimensions of a database table.

Usage

tableOverview(channel, sqtable, max = 1000)

Value

List containing Cols and Rows, describing column data types and the number of rows.

Arguments

channel

an RODBC connection.

sqtable

a database table or view.

max

number of rows to analyze the resulting data frame columns in R. Pass max = 0 to analyze the entire database table.

See Also

sqlColumns, sqlQuery, and tableNrow are the underlying functions used to examine the table/view.

class is the base function to show the class of an object inside the R workspace.

tableHead returns the first rows of a database table.

MSSQL-package gives an overview of the package.

Examples

if (FALSE) {
con <- odbcConnect("myDatabase")

tableOverview(con, "sysusers")

tableOverview(con, "sysusers")$Cols
}