Re: Deleting FK edit t table then replace FK
Hey Richard,
you can do this in two ways:
1) Open the table editor of the referencing table (e.g. double click the table), go to the foreign key section and remove the foreign key there, or
2) (if you have a diagram with the participating tables on it) open that diagram, select the connection that represents the foreign key and press ctrl+del (command+del on the Mac) to remove it. It should ask you if you also want to remove the physical object (here the foreign key) too.
HTH
Mike
Mike Lischke, MySQL Developer Tools
Oracle Corporation
MySQL Workbench on Github:
https://github.com/mysql/mysql-workbench
On Twitter:
https://twitter.com/MySQLWorkbench
On Slack: mysqlcommunity.slack.com (#workbench)
Report bugs to
http://bugs.mysql.com
MySQL documentation can be found here:
http://dev.mysql.com/doc/refman/8.0/en/
Subject
Views
Written By
Posted
2535
July 29, 2009 09:03AM
Re: Deleting FK edit t table then replace FK
1705
August 13, 2009 01:49AM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.