Match column names and classes between local and SQL table

Match column names and classes between local and SQL table

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