Book a Demo

Author Topic: Changing the name of foreign keys to include connectors destination's class name  (Read 3144 times)

KaikuK

  • EA Novice
  • *
  • Posts: 3
  • Karma: +0/-0
    • View Profile
Hello!

We're turning XSD-file into data base and ran into problems regarding the names of the foreign keys during the transform XSD to DDL.
We're trying to change template in transformation editor so that it would name foreign keys differently.

Right now it is using the default naming which gives foreign keys name FK_connectorSourceElemName_connectorDestElemName (name=%qt%%DB_CONSTRAINT_NAME("FK", connectorSourceElemName, connectorDestElemName)%%qt%).

We would want the name to be  FK_connectorSourceElemName_Name of the destination table/class_connectorDestElemName

We are unable to find a working syntax for the "Name of the destination table" so that the foreign keys name would include the table in which the destination element is located.

Any help would be appreciated!

Cheers, Kaiku

KaikuK

  • EA Novice
  • *
  • Posts: 3
  • Karma: +0/-0
    • View Profile
Also is it possible to change table names in the transform template, for example adding XX_ in front of every table name? If so, what is the code syntax to do this.