MSSQL (version 1.0.1)

tableDim: Table Dimensions

Description

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

Usage

tableDim(channel, sqtable)

Value

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

Arguments

channel

an RODBC connection.

sqtable

a database table or view.

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

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

tableDim(con, "sysusers")
}