minimumPK: Find the minimum fields which make a valid Primary Key
In jmaspons/dbTools: Tools for relational databases in R

minimumPK

R Documentation

Find the minimum fields which make a valid Primary Key

Find the minimum fields which make a valid Primary Key

minimumPK(
  x,
  fieldOrder = character(),
  excludeFields = character(),
  maxFields = ncol(x),
  minFieldSet = character()
)

`x`	a `data.frame` equivalent to a table (no duplicated registers, `unique(x)`).
`fieldOrder`	a character vector with the sorted preferences in the fields part of the PK.
`excludeFields`	columns which will be excluded from the potential primary key. Can be the index or the column names.
`maxFields`	maximum number of fields in th primary key.
`minFieldSet`	columns that will be forced to be included in the primary key.