0
Завершен

how to remove foreign key between 2 tables

Ragh Ad 4 года назад обновлен Daniel Dickler 1 год назад 3

Ответ

Ответ
Завершен

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




Ответ
Завершен

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!

Сервис поддержки клиентов работает на платформе UserEcho