Naming template for Key (PK, UK)
Where can I find the rules on how PD 16.5 generates the text it puts in the Name AND Code columns for a Key on a Table. Key could be Primary or Unique.
Right now it is generating a value such as key_1, key_2. I would like it to use the same value as used by ConstraintName, for which I have a rule defined in the DBMS Resource file to generate the value such as PK_tablename, UK_tablename_seqnbr.
Having the Name and Code columns as Key_1 is not impacting the DDL being generated, but when merging the Dev model to Production model, it is getting difficult to identify which changes to merge.
I want to do a similar thing for Name and Code column for References (i.e Relationships). Would like to put the same value as in Constraint name in this case too.
I am using Oracle 10 or 11 databases.