Re: How to change PK and FK name in ER/Studio Version 3.50?

From: Fred Pierce <fpierce_at_avialantic.com>
Date: Fri, 17 Dec 1999 08:40:02 -0500
Message-ID: <385A3D32.2385119@avialantic.com>

Good question. I've been cheating by editing the generated script. I'm sure there's a way but haven't taken the time to figure it out yet. A good place to post this question would be on the ER/Studio forum - http://webboard2.iland.com/~erstudio . This is (IMHO) a good tool but like lots of GUI tools, the reasoning behind there behavior isn't always clear. Be particularly careful to check the generated scripts before modifying a database to be sure it's doing what you want.

fdp

---

Fred Pierce (DNRC) Oracle/Sybase DBA
www.Avialantic.com fpierce_at_avialantic.com MAAM WWII Weekend June 2-4 2000
http://www.maam.org/maamwwii.html
World Airshow News - http://www.wanews.com

---

gmei_at_my-deja.com wrote:

> Hi:
>
> Today is my 2nd day to use ER/Studio to do database design. I have been
> using Designer2K at other companies.
>
> When using ER/Studio, I can create a table and assign a column as PK
> and/or FK, but the constraint names are "fixed" by ER/Studio. For
> example:
>
> CREATE TABLE AreaActivation(
> AreaID VARCHAR2(10) NOT NULL,
> ValidDate DATE,
> ExpiresDate DATE,
> CONSTRAINT PKAreaActivation PRIMARY KEY (AreaID),
> CONSTRAINT RefArea151 FOREIGN KEY (AreaID)
> REFERENCES Area(AreaID)
> )
>
> I want to change it to something like:
>
> CREATE TABLE AreaActivation(
> AreaID VARCHAR2(10) NOT NULL,
> ValidDate DATE,
> ExpiresDate DATE,
> CONSTRAINT PK_AreaActivation PRIMARY KEY (AreaID),
> CONSTRAINT FK_AreaActivation_Area FOREIGN KEY (AreaID)
> REFERENCES Area(AreaID)
> )
>
> Is there a way to do in ER/Studio?
>
> Thanks.
>
> Guang
>
> Sent via Deja.com http://www.deja.com/
> Before you buy.

-- Received on Fri Dec 17 1999 - 07:40:02 CST