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 ...Primary key
> Je me permet de soliciter une aide sur poweramc V8.
> Je suis en charge d'un projet ERP et je me pose la question suivante sur
> exemple de mod�lisation.
> Entit� : ARTICLE
> information : Code article
> Information : Libell� article
> Entit� : Unit�
> Information : Code unit� (exemple : Kg, palette, m2...)
> information : Libell� unit�
> Un article a 3 unit�s, unit� de stockage, unit� de vente et unit� d'achat.
> Ces trois unit�s peuvent �tre diff�rentes.
> Dans mon MCD, j'...2
Does anyone know if I can have a table (tbl1) in one database (db1) linked
with a foreign key to another table (tbl2) in anther databases (db2) on the
db1.tbl1 ==> db2.tbl2
Can tbl1 have triggers to perfrom a cascade delete action on tbl2?
in MS SQLServer
Marc <firstname.lastname@example.org> wrote in message
> Does anyone know if I can have a table (tbl1) in one database (db1) linked
> with a foreign key to another table (tbl2) in anther databases (db2) on
> same server?
> db1.tbl1 ==> db2....foreign keys #2
Can someone explain to me the differences (pros and cons)
to define the foreign key with
versus the use of :
ALTER TABLE dbo.tablename
ADD CONSTRAINT xxxx_FK1
FOREIGN KEY (col_a)
REFERENCES dbo.tablename_b (col_b)
...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
...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...Foreign Key #2
I have two tables and the primary key of Table1 is the foreign key of Table2. In Table2 I set the foreign key to not accept null values. Every time I attempt to submit value using a stored procedure I get an error that the foreign key on Table2 cannot accept a null value. So for testing purposes I set the foreign key value to accept a null value. I then checked Table2 after completing an insert and the value of the foreign key was empty. Can anyone tell me what I need to do to make this work correctly or has anyone run into this issue in the past? Thanks for any help provided!
&...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...Foreign Key #2
I have the following problem:
- In the model, I have tables with cascade foreign key;
- In the database, I have same tables with cascade foreign key;
When I generate the script for the updates to apply the bank, the
PowerDesigner 12.5 always generates scripts for this tables, saying in
model, my foreign key are cascade and in database my foreign key as
What am I doing wrong?
PS: I'm using:
- Sybase PowerDesigner 12.5
- SQL Server 2005 Express
- Windows XP SP3
On Oct 20, 10:59=A0am, "Adriano Santos" <adrianogomessa...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 keys #2
I have two tables, Island and Region.
EXEC SQL CREATE TABLE
Island(islandno integer NOT NULL DEFAULT AUTOINCREMENT,
islandarea integer NOT NULL,
noofregions integer NOT NULL,
EXEC SQL CREATE TABLE
Region(regionno integer NOT NULL,
posx integer NOT NULL,
posy integer NOT NULL,
In Region, I want the islandno to be a foreign key AND a primary key.
How is the foreign key above...binding 1 gridview to 2 tables having common column(primary key/foreign key)
Can anyone please tell me how to bind to 2 tables having a common column(primarykey/foreign key) to a gridview .the 2 tables have a common column(primarykey/foreign key).I want this in asp.net/vb project.Thank you.Gurjeet,England
You can use DataSet, take a look at this link:
http://msdn2.microsoft.com/en-us/library/system.data.dataset(d=ide).aspxWelcome to my SQL/ASPNET forum for Chinese http://51up.org/bbs/forumdisplay.php?fid=38...Cannot drop foreign key constraint in ASE 11.9.2
I need to drop foreign key constraint and drop referenced table, then
create another table-parent to be referenced . The problem is that it
doesn't allow to drop table because of FKey constraint. When I try to
drop the FKey constraint -
it doesn't allow this and doesn't give an error message.
This problem I experience on production server and this should be
fixed urgently but seems like nothing I've tried helps to solve it.
I'm using ASE 11.9.2 on NT4.0.
If anybody has some ideas it would be very appreciated.
<<<< I need to drop ...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...