Book a Demo

Author Topic: DDL Name Template  (Read 2373 times)

jdavid

  • EA User
  • **
  • Posts: 58
  • Karma: +0/-0
    • View Profile
DDL Name Template
« on: December 28, 2007, 08:36:48 am »
We are trying to modify the DDL Name Templates

Question
Why does this work for a constraint:
unq_%tablename%__%columnname%

But this does not work for the primary key:
pk_%tablename%__%columnname%

And this does not work for the foreign key:
fk_%foreigntablename%_%columnname%__to__%primarytablename%_%columnname%

it seems for the primary and foreign keys EA does not like to include the columnname

« Last Edit: December 28, 2007, 08:39:01 am by jdavid »

Paolo F Cantoni

  • EA Guru
  • *****
  • Posts: 8626
  • Karma: +257/-129
  • Inconsistently correct systems DON'T EXIST!
    • View Profile
Re: DDL Name Template
« Reply #1 on: December 28, 2007, 04:10:30 pm »
Yes,

I think that was my analysis also...  Report a bug... I did, some time (maybe six months) back.

The DDL name templates are not consistent... (EAUI)

Paolo
Inconsistently correct systems DON'T EXIST!
... Therefore, aim for consistency; in the expectation of achieving correctness....
-Semantica-
Helsinki Principle Rules!