FK compare during generate DDL

General Questions/Discussions
1

I deleted all entity on ERD and generated ERD from ClassDiagram.
I update my DB from generated ERD, but added constrain have different name as compared with constrain in DB.

For example:
new generated constrain:

ALTER TABLE StaticObject ADD CONSTRAINT FKStaticObje903433 FOREIGN KEY (IDStaticObjectType) REFERENCES StaticObjectType (ObjType);

name of existent constrain: FKSTATICOBJE665733

There are different names of the same constrain. Why?

P.S. FKpattern= ID{reference_table_name}

2

Hi Eugeny,

Thanks for your post. Actually it’s a new constraint. Except reversing from database, new constraint will be generated (in your case, you re-created the ERD from class diagram).

Best regards,
Lilian Wong

3

Can I make name of this constraint is unchangeable?

4

Hi Eugeny,

Thanks for replying. I’m sorry that currently it’s not supported, but we will study the feasibility to support. If there is any news on this issue, I’ll let you know.

Best regards,
Lilian Wong

P.S. Wish you a Merry Christmas and Happy New Year!