tableHead function

First Rows

Return the first rows of a database table.

tableHead(channel, sqtable, n = 3)

Arguments

• channel: an RODBC connection.
• sqtable: a database table or view.
• n: number of rows to get.

Returns

Data frame with the first n rows of the database table or view.

Note

This function can be used to examine the structure of a table or view, along with some example data values.

Examples

## Not run:

con <- odbcConnect("myDatabase")

tableHead(con, "sysusers")

t(tableHead(con, "sysusers", 1))
## End(Not run)

See Also

sqlQuery with tableQuote are the underlying functions used to query the table/view.

head is the base function to return the first parts of an object inside the R workspace.

tableOverview shows the data types and dimensions of a database table.

MSSQL-package gives an overview of the package.