dm (version 0.0.5.9000)

enum_pk_candidates: Which columns are candidates for a primary key column?

Description

enum_pk_candidates() checks for each column of a table if the column contains only unique values, and is thus a suitable candidate for a primary key of the table.

cdm_enum_pk_candidates() performs these checks for a table in a dm object.

Usage

enum_pk_candidates(table)
cdm_enum_pk_candidates(dm, table)

Arguments

table

A table in the dm.

dm

A dm object.

See Also

Other primary key functions: cdm_add_pk(), cdm_get_all_pks(), cdm_get_pk(), cdm_has_pk(), cdm_rm_pk()

Examples

# NOT RUN {
nycflights13::flights %>% enum_pk_candidates()

cdm_nycflights13() %>% cdm_enum_pk_candidates(flights)
cdm_nycflights13() %>% cdm_enum_pk_candidates(airports)
# }