DBI_GetColNames: Retrieve Column Names from an Microsoft SQL Connection
In MARC-GIS/marcR: Helpful Functions Used By The MARC-GIS Team

Description Usage Arguments Value Creation notes Author(s) Examples

View source: R/DBIhelpers.R

Retrieve Column Names from an Microsoft SQL Connection

1	DBI_GetColNames(conn, schema, tableName)

`conn`	A `DBIConnection` object, as returned by `dbConnect()`.
`schema`	Name of schema that table is under. character vector of length 1.
`tableName`	Name of table. character vector of length 1.

Character vector of column names in specified table.

First created in 2020-11-03 with the script OSMdownloadAndSFtoSQLInterface.R in the MARC-KC/HelpLibrary Repository

Jacob Peterson

## Not run: 
library(DBI)

con <- connectODBC("DB_MARC_PRD.marcdl")

tableColNames <- DBI_GetColNames(con, "marcdl", "VW_CovidHospitals")

## End(Not run)