Generate DDL for Foreign Key?

[paky]

I've using EA 3.10 (487) and i'm tring to generate ddl from a data model, but i've the following problem: the foreign key is not exported into database script, is it possible with EA? In documentation, it has been written that it's ok. Why?
I've expressed this foreign key as an operation of a table, as it suggested in documentation. Is it ok? Then is it possible to export the relationships between tables by DDL tool generate?

Thank you very much for your attention !

[Didier Willam]

  I have exactly the same problem even If I use EA differently:

I did a reverse engineering of a DataModel (Sql Server7) and
EA is unable to regenerate correctly the DDL for the foreign key.

Also he does not recognize the indexes in the original DB.

I will post this problem to the ea-support.

[ronnie]

I've got Foreign keys working, but apparently indices aren't supported yet.

To make a foreign key work you have to create an operation in each of the tables (one is done for you when you specify PK - the other you can make just by adding a FK stereotyped operation - make sure after creating the FK operation you re-select it in the list and switch tab to 'fields' and add the appropriate fields to the operation - this is V-Important!).

Then on your association between the classes it's necessary to specify the operations in the source-role and target-role dialogues. This requires that you have the direction of the assocation the right way round - otherwise the wrong operations appear in the wrong drop-down lists.

Hope this helps
Ronnie