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

Home -> Community -> Usenet -> c.d.o.server -> Re: Is Primary Key always the index of the table in Oracle?

Re: Is Primary Key always the index of the table in Oracle?

From: peter <hhh.database_at_gmail.com>
Date: 5 Mar 2007 22:25:33 -0800
Message-ID: <1173162332.932431.154950@p10g2000cwp.googlegroups.com>


On Mar 6, 10:22 am, "Kaka" <kaka...._at_gmail.com> wrote:
> Can someone explain to me if the Primary Key always the same as Index
> of the table in Oracle? If not, how are they related? Thank you in
> advance!

I don't think that primary Key is same as index only. Infact primary key apply a index on column as well as it applies not null and unique constraint and can be use to bind table with another table using foreign key in it. Received on Tue Mar 06 2007 - 00:25:33 CST

Original text of this message

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