Create a new SQL table

create_table creates a new SQL table from a dataframe. It will not append a table if it already exists, nor will it overwrite an existing table. Users should use append_table, truncate_table or overwrite_table to explicitly perform those actions.

Usage

create_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

TRUE invisibly.

See also

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

Examples

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