Re: Primary Keys in Designer 2.1

You can specify that in the implementation of your primary key (In a nutshell: Design Editor, DB Admin tab, expand DB, schema, table and add object index storage).

Major advantage: you can specify different tablespaces for different DB's and schemas

Regards,

Aart-Wichert Groeneveld

S C wrote:

> 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 Sun May 23 1999 - 11:35:45 CEST