Check FK

For example, I have FK Entity1 - Entity2 in Oracle database. When I “generate database” with option “Update Database” FK was generated with new name, but for the same columns. Why?

Hi Eugeny,

Thanks for your post. May I know whether the FK is renamed then you updated the database?
If this is the case, it will generate a new FK to the database (as it has different FK name from the one in database).

Best regards,
Lilian Wong

There isn’t name of FK. It generated automatically and liked as “FKEntityName867495”. It existing in Oracle database, but in DDL-script we can see “ALTER TABLE EntityName ADD CONSTRAINT FKEntityName867495”. Why?

Hi Eugeny,

Thanks for replying. Would you mind to attach your schema (DDL) and project file for checking? If you do not want the files being accessed by public, please send to lilian.wong@visual-paradigm.com

Thanks in advance! Have a nice weekend!

Best regards,
Lilian Wong

Sorry, at existing moment I can’t send my project, because I renaming some attributes…

Hi Eugeny,

Thanks for replying. Our engineers tried that:

  1. have a named FK in database
  2. reverse the database to ERD
  3. modify related entity
  4. generate update database, and there is no new FK created

Would it be possible you prepare a sample schema for us to investigate the issue? Thanks in advance!
You can send the schema to lilian.wong@visual-paradigm.com

Best regards,
Lilian Wong