Get all primary keys of a dm object

Source: R/primary-keys.R

dm_get_all_pks() checks the dm object for set primary keys and returns the tables, the respective primary key columns and their classes.

dm_get_all_pks(dm)

Arguments

dm

A dm object.

Value

A tibble with the following columns:

table

table name,

pk_cols

column name(s) of primary key.

Compound keys

Currently, keys consisting of more than one column are not supported. This feature is planned for dm 0.2.0. Therefore the pk_cols column may contain vectors of length greater than one.

See also

Other primary key functions: dm_add_pk(), dm_get_pk(), dm_has_pk(), enum_pk_candidates()

Examples

dm_nycflights13() %>%
  dm_get_all_pks()

#> # A tibble: 3 x 2
#>   table    pk_col 
#>   <chr>    <keys> 
#> 1 airlines carrier
#> 2 airports faa    
#> 3 planes   tailnum