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: modeling / null-values in composite pk?

Re: modeling / null-values in composite pk?

From: Jan-Erik Rosinowski <spamfilter_at_rosinowski.de>
Date: Sat, 22 Jan 2000 10:53:07 GMT
Message-ID: <388a8300.1323813@News.CIS.DFN.DE>


>Don't use a primary key, instead create a unique index on the three columns,
>same as a primary key but allows NULL values (see post What is Difference
>between Primary Key and Unique Index)

is this standard relational semantic e.g. does sql7 treat this the same way?

anyway, thanks. hadn't known this

ciao, jan

http://www.rsp.de - Software zur effizienten Erstellung und Verwaltung von Gutachten, Analysen, Pruefprotokollen etc. Received on Sat Jan 22 2000 - 04:53:07 CST

Original text of this message

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