Book a Demo
« previous next »
Pages: [1]

Author Topic: Primary and Foreign Key naming  (Read 2223 times)

zen

  • EA Novice
  • *
  • Posts: 1
  • Karma: +0/-0
  • I love YaBB 1G - SP1!
    • View Profile
Primary and Foreign Key naming
« on: February 07, 2007, 05:20:11 am »
Is there a way to define how these names are generated?

Currently EA defines Primary Key as PK_tablename and Foreign Key names as FK_tablename_parenttablename.

I like to define them tablename_pkey and tablename_fk1, tablename_fk2, etc.

Similarly with unique constraints.

Logged

thomaskilian

  • Guest
Re: Primary and Foreign Key naming
« Reply #1 on: February 07, 2007, 10:30:45 am »
You would need to investigate Settings/Transformation templates/DDL
Logged
Pages: [1]
« previous next »