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

Home -> Community -> Usenet -> comp.databases.theory -> Re: unique primary key shared between multiple tables.

Re: unique primary key shared between multiple tables.

From: --CELKO-- <71062.1056_at_compuserve.com>
Date: 20 Mar 2003 15:22:57 -0800
Message-ID: <c0d87ec0.0303201522.29a7367f@posting.google.com>


I just could not stand those names. Try this bit of SQL, which I am not recommending in practice:

CREATE TABLE RentalProperties
(property_nbr INTEGER NOT NULL
 private_owner_nbr INTEGER

     REFERENCES PrivateOwners(owner_nbr),  business_owner_nbr INTEGER

     REFERENCES BusinessOwners(owner_nbr),

Received on Thu Mar 20 2003 - 17:22:57 CST

Original text of this message

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