dm_rm_pk()
removes one or more primary keys from a table and leaves the dm
object otherwise unaltered.
An error is thrown if no private key matches the selection criteria.
If the selection criteria are ambiguous, a message with unambiguous replacement code is shown.
Foreign keys are never removed.
Arguments
- dm
A
dm
object.- table
A table in the
dm
. PassNULL
to remove all matching keys.- columns
Table columns, unquoted. To refer to a compound key, use
c(col1, col2)
. PassNULL
(the default) to remove all matching keys.- ...
These dots are for future extensions and must be empty.
- fail_fk
Boolean: if
TRUE
(default), will throw an error if there are foreign keys addressing the primary key that is to be removed.
See also
Other primary key functions:
dm_add_pk()
,
dm_get_all_pks()
,
dm_has_pk()
,
enum_pk_candidates()
Examples
dm_nycflights13() %>%
dm_rm_pk(airports, fail_fk = FALSE) %>%
dm_draw()