Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.tools -> Oracle table creation script question

Oracle table creation script question

From: TC <cleavet_at_my-Deja.com>
Date: 12 Jun 2001 13:06:08 -0700
Message-ID: <663711ac.0106121206.235c1e1c@posting.google.com>

Hi,

I have a table creation script in hand (written by another guy), and I'm trying to figure out why exactly the primary keys are created as they are:

For each table, the following sequence of steps is performed:

  1. The table is defined, except that no column is designated as the PK.
  2. A unique index is created on a column (the PK-designate).
  3. An ALTER TABLE ADD CONSTRAINT command is issued to add the PK constraint on that column.

Can someone comment on the benefits of doing things this way? Full storage parameters are included in steps 1 & 2, if that helps.

Thanks for any assistance,
Tom C. Received on Tue Jun 12 2001 - 15:06:08 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US