Re: Primary Keys in Designer 2.1

From: S C <shiuc_at_home.com>
Date: Sat, 22 May 1999 12:13:24 GMT
Message-ID: <Ebx13.12138$vP2.7259_at_news.rdc1.tn.home.com>


[Quoted] If I want to have the PK index in a specific tablespace, how do I specify that?

Geoff White <whiteg_at_ccis.adisys.com.au> wrote in message news:3744D50A.8037D001_at_ccis.adisys.com.au...
> Douglas Scott wrote:
>
> > I have been trying to learn what Designer 2.1 generates in certain
> > circumstances. I created both primary and foreign keys on a set of
> > tables and generated the DDL for those tables. I noticed that the
> > resulting script created primary and foreign key constraints, but it
> > only created indexes for the foreign keys. Doesn't Designer create
> > indexes for primary keys or am I doing something wrong?
> >
> > Douglas Scott
> > Douglas.S.Scott_at_USAHQ.unitedspacealliance.com
>
>
> The index is created implicitly when the primary key is created so it
> doesn't need to be included in the script.
>
> Geoff
>
>
Received on Sat May 22 1999 - 14:13:24 CEST

Original text of this message