sqlAddIndex: generate sql for an alter table statment adding an index to...

In schardtbc/DBIExt: Extentsion for DBI; new Generics

Description

suggest that this be done prior to adding any data to the table.

Usage

sqlAddIndex(conn, table, index, unique = FALSE, ...)

Arguments

conn	a DBIConnector Object
table	table in database to which primary key will be added
index	a character vector of column names which make up the index for the table
unqiue	boolean specifying if index is unique (a rows must have a unique value)

Details

'sqlAddIndex()' composes a single SQL statement to add a composite primary key to a table in the database

See Also

Other SQL generation: sqlAlterTableWithPrimaryKey, sqlDeleteAllRecords, sqlOnClause, sqlReplaceInTable, sqlSetClause, sqlUpdateTable

schardtbc/DBIExt documentation built on June 7, 2019, 2:39 p.m.