dm_rm_fk {dm} R Documentation

## Remove foreign keys

### Description

dm_rm_fk() can remove either one reference between two tables, or multiple references at once (with a message). An error is thrown if no matching foreign key is found.

### Usage

dm_rm_fk(
dm,
table = NULL,
columns = NULL,
ref_table = NULL,
ref_columns = NULL,
...
)


### Arguments

 dm A dm object. table A table in the dm. Pass NULL to remove all matching keys. columns Table columns, unquoted. To refer to a compound key, use c(col1, col2). Pass NULL (the default) to remove all matching keys. ref_table The table referenced by the table argument. Pass NULL to remove all matching keys. ref_columns The columns of table that should no longer be referencing the primary key of ref_table. To refer to a compound key, use c(col1, col2). ... These dots are for future extensions and must be empty.

### Value

An updated dm without the matching foreign key relation(s).

Other foreign key functions: dm_add_fk(), dm_enum_fk_candidates(), dm_get_all_fks()