tableDim {MSSQL} | R Documentation |
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)
[Package MSSQL version 1.0.0 Index]