tableDim: Table Dimensions

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

Table Dimensions

Description

Return the number of rows and columns in a database table.

Usage

tableDim(channel, sqtable)

Arguments

channel	an RODBC connection.
sqtable	a database table or view.

Value

Vector of length two, containing the number of rows and columns.

See Also

tableNrow and tableNcol are the underlying functions to get the number of rows and columns in a database table.

dim is the base function to return the dimensions for data frames inside the R workspace.

MSSQL-package gives an overview of the package.

Examples

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

tableDim(con, "sysusers")

## End(Not run)

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