Re: Adding a Foreign Key without Constraints

[Mike Lischke]

Hi George,

when you open the table editor and go to the foreign key section there's a checkbox "Skip on SQL generation", which you can set for each FK individually. Would that help?

If you however *want* the FKs and just disable cascaded actions then set ON UPDATE and ON DELETE to NO ACTION using the drop down boxes.

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/



Edited 1 time(s). Last edit at 11/09/2012 03:15AM by Mike Lischke.