Trying to Create Named Foreign Keys in ER-Win
From: Sean Phelan <sphelan_at_harris.com>
Date: Tue, 25 Jan 2000 21:45:56 GMT
Message-ID: <oQoj4.466$Wy5.15228_at_newsread1.prod.itd.earthlink.net>
[Quoted] Hi all,
PK:
alter table T_PROC_DETAILS
add constraint PK_PROC_DETAILS
PRIMARY KEY (PROC_ID); FK:
alter table T_CURRENCY_EXCHANGE
add constraint FK_CURRENCY_EXCHANGE
FOREIGN KEY(CURRENCY_CODE)
REFERENCES CURRENCY(CURRENCY_CODE)
Date: Tue, 25 Jan 2000 21:45:56 GMT
Message-ID: <oQoj4.466$Wy5.15228_at_newsread1.prod.itd.earthlink.net>
[Quoted] Hi all,
Has anyone successfully used ER-Win to model an Oracle Database, naming the foreign key constraints?
The desired DDL looks like:
PK:
alter table T_PROC_DETAILS
add constraint PK_PROC_DETAILS
PRIMARY KEY (PROC_ID); FK:
alter table T_CURRENCY_EXCHANGE
add constraint FK_CURRENCY_EXCHANGE
FOREIGN KEY(CURRENCY_CODE)
REFERENCES CURRENCY(CURRENCY_CODE)
Using ER-Win's Post-Script feature with Macros, I've successfully built the Primary Keys, but the Foreign key issue is killing me.
In the end, it's more an Er-Win question than an Oracle question, but I figured I might get lucky. Any one know how to do it?
Or, alternatively, does anyone know of an ERWin newsgroup?
TIA, Sean Phelan Received on Tue Jan 25 2000 - 22:45:56 CET