Re: Preferred method in creating primary key

From: Jack Wang <nospam_at_nospam.com>
Date: Thu, 14 Aug 2003 17:17:15 GMT
Message-ID: <vuP_a.17033$zE1.14771@edtnps84>

We got nonunique index name same as pk. Consider,

CREATE TABLE T1... ALTER TABLE T1 ADD (
  CONSTRAINT T1_PK PRIMARY KEY (Y)
    DEFERRABLE INITIALLY IMMEDIATE
    USING INDEX
    TABLESPACE INDX); SELECT INDEX_NAME, UNIQUENESS FROM USER_INDEXES WHERE TABLE_NAME='T1';

INDEX_NAME                     UNIQUENES
------------------------------     ---------
T1_PK                                    NONUNIQUE

>
> Sure, but do you *really like* those sys_#$%& objects? With Normans
aproach
> you end up with (hopefully) meaningful names.
>
>
> Cheers,
>
> Holger
>
Received on Thu Aug 14 2003 - 12:17:15 CDT