Skip to contents

Match column names and classes between local and SQL table

Source: R/insert_table.R
match_dbcols.Rd

Match column names and classes between local and SQL table

Usage

match_dbcols(values, table, con, coerce_col_class = TRUE, drop = TRUE)

Arguments

values

`data.frame` of values to write to SQL database

table

Name of target SQL table, as character

con

Database connection object

coerce_col_class

logical, whether or not to coerce local data columns to SQL classes. Default = `TRUE.`

drop

logical. If `TRUE` (default), drop columns not found in SQL table.

Value

`values` `data.frame` with column names and classes matched to SQL