0
Completed

how to remove foreign key between 2 tables

Ragh Ad 4 years ago updated by Daniel Dickler 2 months ago 3

Answer

Answer
Completed

Hello,


Please select the reference (the line between 2 tables) and then push "Delete" button on the keyboard.

Please note that this operation will also remove a column from the foreign key table.

Best regards,

Adam Mościcki




Answer
Completed

Hello,


Please select the reference (the line between 2 tables) and then push "Delete" button on the keyboard.

Please note that this operation will also remove a column from the foreign key table.

Best regards,

Adam Mościcki




Can we make the deletion of the column from the foreign key table optional? Sometimes we need to replace a table that carries the primary key and in that case the the foreign key field(s) which can affect many tables becomes a very difficult exercise to bring those FK fields back to the affected tables. 

I figured out how to accomplish that. First edit the foreign key and remove the relationship. Then remove the connecting line. That way the previous referenced foreign key column will not be deleted from the table. So we implicitly have the option to delete the foreign key column or not. Happy!