MSSQL-package {MSSQL}

Tools to Work with Microsoft SQL Server Databases via RODBC

Description

Tools that extend the functionality of the RODBC package to work with Microsoft SQL Server databases. Makes it easier to browse the database and examine individual tables and views.

Details

Browse database:

dbOverview	Dimensions and column names
dbStorage	Storage size
dbTime	Time created and modified

Browse table:

tableDim	Dimensions
tableHead	First rows
tableNcol	Number of columns
tableNrow	Number of rows
tableOverview	Data types and dimensions

Helper functions:

tableQuote

Quote table name

Note

browseVignettes() shows a vignette with implementation notes.

Author(s)

Arni Magnusson.

See Also

This package complements the RODBC package and does not replace the standard query methods.

For example, the user may find dbOverview and tableOverview more convenient than the underlying sqlTables and sqlColumns, but to query the database sqlQuery or sqlFetch are still used in the normal way.