Truncate and Append a SQL table - Preserving Structure

Truncate and append data to a SQL table without losing SQL identities and without changing the table structure.

Usage

overwrite_table(.data, conn, database, schema, table)

Arguments

.data

Dataframe to append to the SQL table.

conn

A DBIConnection object, as returned by DBI::dbConnect().

database

Name of database or catalog.

schema

Name of schema.

table

Name of table.

Value

A scalar numeric.

See also

Other basics: append_table(), create_table(), nuke_table(), read_table(), survey_table(), truncate_table()

Examples

if (FALSE) { # \dontrun{
overwrite_table(
  .data = my_dataframe,
  conn = my_connection,
  database = "my_database",
  schema = "my_schema",
  table = "my_table"
)
} # }