Re: Trying to Create Named Foreign Keys in ER-Win
Date: Thu, 27 Jan 2000 20:19:18 GMT
Message-ID: <aL1k4.1905$%87.53670_at_newsread1.prod.itd.earthlink.net>
Everyone,
Thanks for the advice. What I ultimately came up was this:
- Turn off Foreign Key/Primary key generation on the tables.
- Add 2 Post-table scripts, one to alter and add the PK, one to alter and add all the FK's, dynamically building the name off the table and columns.
What I was trying to avoid was having to manually maintain the names as my database grew more complex.
I've attached the Er-win scripts for those who are interested.
Thanks,
Sean
begin 666 erwin_tricks.txt
M3U)!0TQ%("T_at_4%))34%262!+15D_at_0U)%051)3TX_at_5TE42"!!3%1%4B!404),
M12 H4&]S="U38W)I<'0I._at_T*+2TM+2TM+2TM+2TM+2TM+2TM+2TM+2TM+2TM
M+2TM+2TM+2TM+2T-"F%L=&5R('1A8FQE("5486)L94YA;64_at_#0IA9&0_at_8V]N
M<W1R86EN="!02U\E16YT:71Y3F%M92_at_I( T*4%))34%262!+15D@*"5&;W)%
M86-H071T*%!A<F5N="P_at_(BP@(BD@>R5)9B_at_E071T27-02RD@>R5!='1.86UE
M?7TI.PT*+2TM+2TM+2TM+2TM+2TM+2TM+2TM+2TM+2TM+2TM+2TM+2TM+2TM"
D]204-,12 M($9/4D5)1TX_at_2T59($-214%424].(%=)5$@@04Q415(@5$%"
M3$4_at_*%!O<W0M4V-R:7!T*3H@#0HM+2TM+2TM+2TM+2TM+2TM+2TM+2TM+2TM
M+2TM+2TM+2TM+2TM+0T*)49O<D5A8VA#:&EL9%)E;"_at_I('L-"D%,5$52(%1!
M0DQ%("5#:&EL9" -"D%$1"!#3TY35%)!24Y4($9+7R5%;G1I='E.86UE*"5#
M:&EL9"E?)49O<D5A8VA&2T%T="_at_E0VAI;&0I('LE071T1FEE;&1.86UE?0T*
M1D]214E'3B!+15D_at_*"5&;W)%86-H1DM!='0H)4-H:6QD*2![)4%T=$9I96QD
M3F%M97TI#0I2149%4D5.0T53("5087)E;G0_at_*"5&;W)%86-H071T*"5087)E
M;G0I('LE268H)4%T=$ES4$LI('LE071T3F%M97U]*3L-"GT-"BTM+2TM+2TM
M+2TM+2TM+2TM+2TM+2TM+2TM+2TM+2TM+2TM+2TM#0I/4D%#3$4_at_+2!62457
M($123U O0U)%051)3TX_at_1D]2(%1!0DQ%*%!O<W0M4V-R:7!T*0T*+2TM+2TM
M+2TM+2TM+2TM+2TM+2TM+2TM+2TM+2TM+2TM+2TM+2T-"F1R;W _at_=FEE=R E
M16YT:71Y3F%M92_at_I.PT*8W)E871E('9I97<@)45N=&ET>4YA;64H*2!A<R!S
M96QE8W0_at_*B!F<F]M(%1?)45N=&ET>4YA;64H*2 [#0HM+2TM+2TM+2TM+2TM
M+2TM+2TM+2TM+2TM+2TM+2TM+2TM+2TM+0T*3U)!0TQ%("T_at_4T51545.0T4@
M0U)%051)3TX_at_1D]2(%1!0DQ%("A0;W-T+5-C<FEP="D-"BTM+2TM+2TM+2TM
M+2TM+2TM+2TM+2TM+2TM+2TM+2TM+2TM+2TM#0ID<F]P('-E<75E;F-E('-E
M<5\E16YT:71Y3F%M92_at_I.PT*8W)E871E('-E<75E;F-E('-E<5\E16YT:71Y
M3F%M92_at_I.PT*+2TM+2TM+2TM+2TM+2TM+2TM+2TM+2TM+2TM+2TM+2TM+2TM
$+2T-"_at_``
`
end
Received on Thu Jan 27 2000 - 21:19:18 CET