sqlAlterTableWithPrimaryKey: generate sql for an alter table statment adding a primary key...

In schardtbc/DBIExt: Extentsion for DBI; new Generics

Description

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

Usage

sqlAlterTableWithPrimaryKey(conn, target.table, pk, ...)

Arguments

conn	a DBIConnector Object
target.table	table in database to which primary key will be added
pk	a character vector of column names which make up the composite primary key for the table

Details

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

See Also

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

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