Export from ERD to SQL - relationships incorrect

0

I'm exporting an ERD to SQL Server. The diagram consists of one entity with relationships to three other tables. Looking at the generated SQL, the foreign keys are set up incorrectly. A FK that references table A, for example, uses the column that is the foreign key to table B.

Am I doing something wrong? Any way to fix this other than manually edit the generated SQL each time I export?

2 comments

0

I found the problem. The relationships need to be connected to the corresponding table at the connection points for the corresponding columns. 

Issue resolved.

0
Abigail M
Lucid Manager

Hi Paul, thanks for following up with that resolution! If anyone else is experiencing issues with ERD > SQL export, feel free to post your question in this thread.