Re: Primary Keys

In <Pine.SUN.3.91.950419121911.24924D-100000_at_seatimes> Steve Butler

>
>> The primary key constraint creates a unique index, but it
>> uses a system-generated name and defaults the storage and
>> tablespace. For that reason, our shop is putting a standard
>> in place that constraints are to have the index name
>> and storage info created explicitly.
>
>Perhaps in versions prior to 7.0.16. (There was a minor problem I ran
 

>into in 7.0.13 having to do with EXP and IMP.)
>
>Now you can specify the storage paremeters and tablespace for the
 primary
>key constraint within the CREATE TABLE statement.

Does it allow a separate tablespace for the primary key or does the pk have to be in the same tablespace as the table itself? Received on Wed Apr 19 1995 - 00:00:00 CEST