create_indexes: create_indexes creates indexes onto an existing table

Description Usage Arguments Value Examples

Description

Creates indexes onto an existing table within a database

Usage

1
create_indexes(con, table, indexes = NULL, unique = FALSE, ...)

Arguments

conn:

Connection to database. Can used assigned output from function connectR for the connection.

table:

Name of table on the database

indexes:

a vector of column names to become indexes for a table.

unique:

Specifies if the indexes are unique or not (TRUE or FALSE).

Value

Indexes on a table

Examples

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

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