tableOverview function

Data Types and Dimensions

Show data types and dimensions of a database table.

tableOverview(channel, sqtable, max = 1000)

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.

Returns

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

Examples

## Not run:

con <- odbcConnect("myDatabase")

tableOverview(con, "sysusers")

tableOverview(con, "sysusers")$Cols
## End(Not run)

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.