Re: Where is a Foreign Key stored?

Rory Skelly wrote:
>
> Greetings from an Oracle DBA-in-the-making
>
> My question has to do with adding foreign key constraints.
>
> When creating Primary or Unique Key constraints you can specify the index
> to use (and where it will be located etc.) but with Foreign Keys you don't
> have that option.
>
> 1. What object is created when you add a Foreign Key constraint?
> 2. In which tablespace is it created?
>

  Unique key (including primary key) is enfored by using CREATE UNIQUE INDEX. For the foreign key, they are implemented by the index created from the unique or the primary key.

---
Name   : Lun Wing San
Title  : Oracle Application Developer of Hong Kong Productivity Council
         Oracle Database Administrator and System Administrator of QRC
Phone  : (852)27885841

This posting represents the personal opinions of the author. It is not the
official opinion or policy of the author's employer. Warranty expired when you
opened this article and I will not be responsible for its contents or use.