Re: Primary Keys in Designer 2.1
From: Geoff White <whiteg_at_ccis.adisys.com.au>
Date: Fri, 21 May 1999 11:37:46 +0800
Message-ID: <3744D50A.8037D001_at_ccis.adisys.com.au>
Date: Fri, 21 May 1999 11:37:46 +0800
Message-ID: <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 Fri May 21 1999 - 05:37:46 CEST