okay this is the issue
When you generate the PDM from the CDM, PowerDesigner generates, using
its own naming convention, the foreign key column that is placed in the
physical model table - we want to have control over this column name ie:
we want this foreign key column to be called f_key in our physical
table. Please note we are not talking about FK/PKconstraints names etc,
we are talking about the actual column name of the foreign key.
We have searched through the definition file and cannot find where its
Or is this not possible to control in PowerDesigner and you have ...Attempt to over-write foreign key column "Code" where table A has 3 foreign keys to table X
Generating from CDM to Logical.
This is a weird one - 4 tables in my model have more than one foreign key
reference to table COROrg. By default a foreign ket to COROrg generates as
COROrgKy. I have renamed the other foreign keys appropriately - e.g.
COROrgKyEmpGrp. After the rename when I generate from CDM to Logical
everything's fine for all but on of the foreign key columns (i.e. the new
name/code are maintained in all but one).
The list of changes to happen (obtained from Merge dialog -> Merge Preview)
says it's going to
'Modify Column "...foreign key error during upgrade 3.0.3 -> 3.4.4
I'm upgrading our bugzilla system from 3.0.3 to 3.4.4 running on Fedora
12. Our MySQL bugs database also needs the UTF-8 conversion. Near the
end, checksetup.pl quits with the following error :
Adding foreign key: whine_queries.eventid -> whine_events.id...
DBD::mysql::db do failed: Can't create table 'bugs.#sql-130a_11' (errno:
150) [for Statement "ALTER TABLE whine_queries ADD
CONSTRAINT fk_whine_queries_eventid_whine_events_id FOREIGN KEY
ON UPDATE CASCADE ON DELETE CASCADE"] at ...Upgrade 3.2 -> 3.4: problems with foreign keys
As I mentioned the other day, I'm trying to upgrade us stepwise, 3.0
-> 3.2 -> 3.4 -> 3.6 -> 4.0. (My theory is that smaller steps should
be less painful upgrades, especially when merging our customizations
with Bugzilla changes.)
First, if this is a dumb way to upgrade, please let me know. I've been
beating my head against a schema upgrade problem going from 3.2 ->
3.4, and perhaps there is a better way: e.g. 3.0 -> 3.4, or 3.2 ->
Second, I'm getting two problems adding foreign key constraints.
1) inconsistent types:
Adding foreign ...Foreign key name
I am using PD 11 . The scenario is:
when I create two relations between 2 tables (one with role name and the
other without role name) then generate the physical model, and use the
%PROLE% as FK column name .
when the model generates , one FK gest the role name and the others that
gest the table name as FK. I want to change the default of tabel name to
is there any one that knows the solotion?
The default behavior is for the parent table column name to be used as
the FK column. The columns from the first reference should be the
...Name of foreign key
I am working on a program we bought. The previous developpers used PowerAMC
and I can't find where they precised the way to name foreign keys.
Exemple : if the table "Bill" has a reference to the table "Supplier", when
I generate the MPD, the reference is converted this way in the table BILL :
I want to know where "ID_%TABLE%" is defined ?
Otherwise, is it possible for certain foreign keys to define in the MCD the
name they will have in the MPD ? Exemple : I have an other table where I
want one foreign_key to have a special n...Foreign Key Names
I can't seem to figure out where to set the Foreign Key Naming convention.
As I generate from a CDM to PDM how do I take control of how relationships
are migrated and named. and, what documentation should I read to get a
better handle on this?
OK, you do not have any control over the default foreign key names in the
initial CDM -> PDM generation. However, after you change it in the PDM, the
next time you generate PD will abide by your names.
Michael F. Nicewarner [TeamSybase]
"Coy Lay" <email@example.com...Name Of Foreign Key
I'm using SQL Any50, ORACLE, and SQL Server 6.5 with a PB 6.0 Application.
I'm looking for a solution to get the name of the Foreign Key, for some
of my application.
Is there someone who know where i can find it in the system table ?
In Oracle, you need to look at either the ALL_CONSTRAINTS or the
In SQL Server 6.5, you would look at the SYSREFERENCES table.
I'm not sure where you'd look in SQL Anywhere.
Ron Gallagher, CPDP
Steph w...Table design question (to foreign key or not to foreign key)
Our application is a message board and is full of messages, threads, and
forums. A message is an individual entry (like the one I'm typing now ;)).
Our software gives the user the ability to upload a single file attachment
to each message.
I can think of a couple different ways to design the two tables:
message( messageid numeric identity, attachmentid numeric null, messagetext
text, other, message, stuff... )
attachment( attachmentid numeric identity, title varchar, other, stuff )
message( messageid, messagetext text, other, stuff )
attachment( messageid numeric foreig...Naming foreign keys PD9
I would like to change the standard way of naming the foreign keys in the
PDM. In the DBMS definition, I change ConstName
(Script->Objects->Reference->ConstName) and it works:
leads to the name
Now, I would like to include the name of the referenced parent primary key
column (in this particular model, there is always only one column
I've tried almost all variables listed in the PDM reference guide, but I
don't get there...Foreign key names #2
I like to have all my foreign key names set to FK_%PARENT%_%CHILD% so that I
have an idea of what the link is. When I set this up in Rebuild Indexes, I
get sporadic parent and child table names.
For example, I have 3 tables Template, Customer & Store. When I set up an
FK between Template (child) and Customer (parent) I get FK_CUSTOMER_STORE.
Sure enough there is an FK between Customer & Store but why is it being
OK, are you wanting to control the names of indexes or foreign key
You can't use %PARENT% or %CHILD%...Multiple Foreign Key names
Table A B C
Column a pk a pk a fk1, fk2
aa b c
aaa c d
A and C are linked by reference D.
B and C are linked by reference E.
I can see that fk1, fk2 are displayed in C table.
I hope that fk is only displayed in C table.
I am not sure I understand what you need to see. When you fold a foreign
key like you have with column a in table C, it is important to know it is a
foreign...Naming of foreign keys in the PDM
When I have relationships between two tables, I cannot
influence the name of the foreign key field which is generated.
I have two tables: customer, user
I have two user references in the customer table, the user who manages the
and the user who created the customer record. When I generate the PDM I
get the field names "id_user" and "id_user2" which are not really useful. I
"managing_user" and "creation_user".
Is there a way to influence these names?
Neudorfstr...Powerdesigner foreign key trouble
I have a problem in a CDM with the link among the table that become a
problem in the PDM.
By example, I have to connect tre entity with relation one-many and in
every entity I have the same attribute, ex. CODE.
If I have to connect two entity to the third entity, but powerdesigner
on the conversion from CDM to PDM inserts yhe attribute CODE from every
entity on the third part and translate the CODE to %TABLE_NAME%_CODE.
I would to be one only CODE on the third entity and the code of any
contraints to be ...reference to only parent code.
Can anyone help me ? (sorry for my poo...