db_create_primary: db_create_primary creates empty table with primary indexes/...

In DyfanJones/connectR: Database backend for DBI, dplyr and dbplyr

Description

Creates a table in the database from a dataframe and creates primary keys/ indexes

Usage

db_create_primary(conn, name = NULL, value = NULL, primary = NULL,
  query = FALSE)

Arguments

conn:	Connection to database. Can used assigned output from function connectR for the connection.
name:	Name of table on the database
value:	Data.frame
primary:	Column(s) to created to primary keys / indexes.

Value

Empty table in database with primary keys/ indexes

Examples

 #Creates a table with no data on the database, but allows primary
 keys/indexes to be created:
   db_create_primary(post, "testdata", testdata, c("col1","col2"))

DyfanJones/connectR documentation built on May 23, 2019, 10:32 p.m.