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 -> foreing key on part of a primary key

foreing key on part of a primary key

From: Stephane sinet <sinet_at_auto-contact.com>
Date: Wed, 8 Sep 1999 16:07:47 +0200
Message-ID: <7r5qi3$1as$1@minus.oleane.net> 





Hello,


I have to develop a multilanguage software, so all tables containing a label
have


a primary key with code + code language.
ex : my table COLOR -> code color, code language, label color
However i don't want to have the code language in all other tables who
reference the color.


How can i do, to refer to the color and have the constraint, i.e to forbid
the delete of a color if it is referenced by another table.
Thanks.


Received on Wed Sep 08 1999 - 09:07:47 CDT












Original text of this message













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