Delete row(s) from table

dbDelete(
  db,
  table,
  params,
  sql = NULL,
  run = TRUE,
  log.dir = NULL,
  do.log = !is.null(log.dir),
  user = NA,
  where.in = FALSE
)

Arguments

db

dbi database connection

table

name of the table

params

named list of values for key fields that identify the rows to be deleted

sql

optional a parameterized sql string

run

if FALSE only return parametrized SQL string