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: URGENT: Primary key vs Unique Index

Re: URGENT: Primary key vs Unique Index

From: Mars <mars_at_mediadata.com.sg>
Date: 1997/02/25
Message-ID: <33133DFD.6162@mediadata.com.sg>#1/1

Bill Bearden wrote:
>
> There are two important differences between Primary and Unique Keys.
>
> 1. There can only be one Primary Key on a table. There can be more than
> one column with Unique Key.
> 2. Primary Key columns can't contain NULL. Unique Key columns can.
>

Pardon my ignorance but why can't a primary key be NULL ? Is it a rule or is it specific to just Oracle ?

rgds,
mars Received on Tue Feb 25 1997 - 00:00:00 CST

Original text of this message

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