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

Home -> Community -> Usenet -> c.d.o.misc -> Re: Foreign Key / Auto Increment

Re: Foreign Key / Auto Increment

From: Mark D Powell <Mark.Powell_at_eds.com>
Date: 4 Jan 2005 17:06:15 -0800
Message-ID: <1104887175.719533.245300@f14g2000cwb.googlegroups.com> 





If by auto_increment column you mean sequence generated key value then
yes it would be fine to reference the PK of the parent table from the
child table.  In the case of an inherited key in the child table how
else would you do it?



HTH -- Mark D Powell --
Received on Tue Jan 04 2005 - 19:06:15 CST












Original text of this message













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