CODEWITHSUNDEEP
mysqlmysql-workbench
LINKeRxUA
LINKeRxUA

Reputation: 559

MySQL Workbench. Way to generate foreign keys in forward engineering as alter table statements?

Is there any option in MySQL forward engineering which can generate FOREIGN KEYS as ALTER TABLE STATEMENT?

Upvotes: 2

Views: 1705

Answers (1)

Mike Lischke
Mike Lischke

Reputation: 53502

Forward engineering in MySQL Workbench is the process of applying a modell as a whole on the target server. Existing objects are "overwritten".

In your case use the synchronization feature (a 2-way merge) that allows to apply individual changes via ALTER TABLE etc. on the target db. At the same time changes in the target schema that are not yet in the model are taken over, so both model and server are in sync after that.

enter image description here

Upvotes: 4

Related Questions