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
Date: 1995/04/24
Message-ID: <Pine.SUN.3.91.950424082530.8861A-100000_at_seatimes>#1/1
On 19 Apr 1995, Chuck Hamilton wrote:
> >Now you can specify the storage paremeters and tablespace for the
> 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
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