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: DA Morgan <damorgan_at_x.washington.edu>
Date: Tue, 04 Jan 2005 22:33:06 -0800
Message-ID: <41db88f0$1_4@127.0.0.1>


Nouman Shah wrote:

> Is it ok to reference an auto-increment column (of parent table) as a foreign key in a child table?

There is no such thing as an autoincrement column in Oracle. Please provide the following:

  1. Name of product and version you are using
  2. Describe of the table in question

But likely the answer, in any database product, is that a reference or SELECT can do no harm.

-- 
Daniel A. Morgan
University of Washington
damorgan_at_x.washington.edu
(replace 'x' with 'u' to respond)
Received on Wed Jan 05 2005 - 00:33:06 CST

Original text of this message

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