Re: Primary Keys

From: Steve Butler <sbut-is_at_seatimes.com>
Date: 1995/04/24
Message-ID: <Pine.SUN.3.91.950424082530.8861A-100000_at_seatimes>#1/1


On 19 Apr 1995, Chuck Hamilton wrote:
> 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
 

> >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?

Yes, you can give ALL constaints (primary, unigue, referential, etc) NAMES, and specify tablespace name and storage parameters for each index right in the CREATE TABLE syntax.

+----------------------------------------------------+
| Steve Butler          Voice:  206-464-2998         |
| The Seattle Times       Fax:  206-382-8898         |
| PO Box 70          Internet:  sbut-is_at_seatimes.com |
| Seattle, WA 98111    Packet:  KG7JE_at_N6EQZ.WA       |
+----------------------------------------------------+
All standard and non-standard disclaimers apply. All other sources are annonymous. Received on Mon Apr 24 1995 - 00:00:00 CEST

Original text of this message