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

From: <gmei_at_my-deja.com>
Date: Wed, 15 Dec 1999 15:23:20 GMT
Message-ID: <838bp3$3ri$1@nnrp1.deja.com>

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 Wed Dec 15 1999 - 09:23:20 CST