DBI_AppendSFtoTable: Append sf table to a Microsoft SQL table
In MARC-GIS/marcR: Helpful Functions Used By The MARC-GIS Team

Description Usage Arguments Creation notes Author(s) Examples

View source: R/DBIhelpers.R

Append sf table to a Microsoft SQL table

DBI_AppendSFtoTable(
  conn,
  sfTable,
  schema,
  tableName,
  createTableQuery = NULL,
  warnings = getOption("warn")
)

`conn`	A `DBIConnection` object, as returned by `dbConnect()`.
`sfTable`	sf object to append to specified database table
`schema`	Name of schema that table is under. character vector of length 1.
`tableName`	Name of table. character vector of length 1.
`createTableQuery`	Currently unused. Always NULL
`warnings`	Warning key. Use `-1` to hide warning messages in function.

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")

#This is not set up to be a real example
tableColNames <- DBI_AppendSFtoTable(con, sfTable, "marcdl", "TestTable")

## End(Not run)