tableOverview: Data Types and Dimensions

In MSSQL: Tools to Work with Microsoft SQL Server Databases via 'RODBC'

Data Types and Dimensions

Description

Show data types and dimensions of a database table.

Usage

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.

Value

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

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

## Not run: 
con <- odbcConnect("myDatabase")

tableOverview(con, "sysusers")

tableOverview(con, "sysusers")$Cols

## End(Not run)

MSSQL documentation built on Oct. 22, 2024, 9:06 a.m.