Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It's 100% free, no registration required.

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

I've made an ERD in MySQL Workbench, where I added foreign keys to visualize the relationships. In the actual database I want to work without the foreign keys (I'll organize that in my application).

When I export a create script, there is somewhere a function called "skip creation of foreign keys" or anything like that.

Now I want to sync the model directly with my database, but it looks like there is no equivalent option in the synchronization function.

I can also not find this option in the wizard for exporting an alter script, which would also be ok.

Am I just missing it or is that impossible?

share|improve this question
Workbench is trying to protect you from the dangerous choice of having no FKs :) – ypercubeᵀᴹ Jul 3 '13 at 14:07
I think there are pretty long discussions about the pros and cons. After reading for 2 hours and maybe 1/1000 of it I decided to go without. :D – Marcel Jul 3 '13 at 14:11
Don't do it. Why don't you leave the FKs there? And still deal with them ("organize") in the application. It doesn't hurt, really to have everything double checked. Plus, you can sleep at night without fear of the database losing data integrity. – ypercubeᵀᴹ Jul 3 '13 at 14:13
Maybe I add them later on, I don't know. Right now it would just get on my nerves because I have a lot of changes and the fks are always crying. – Marcel Jul 3 '13 at 14:21
For example I have MyISAM tables. I do not what to use innoDB. But I what to visualise relations in model so that other developers understand the DB structure. Then what? – Sergey Romanov Jan 1 '15 at 13:14

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

Browse other questions tagged or ask your own question.