tableHead: First Rows

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

First Rows

Description

Return the first rows of a database table.

Usage

tableHead(channel, sqtable, n = 3)

Arguments

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

Value

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.

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.

Examples

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

tableHead(con, "sysusers")

t(tableHead(con, "sysusers", 1))

## End(Not run)

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