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 -> foreign key missing

foreign key missing

From: Gennady <gennadyb_at_halcosoftware.com>
Date: Wed, 24 Mar 1999 15:28:19 -0800
Message-ID: <36f97508$0$12042@fountain.mindlink.net>


I created dependant table SQL script like this: CREATE TABLE LumberSizes (

    LSizes number(11),
    LbrGroup Varchar2(30),
    LbrSize Varchar2(30),

    NomThick Number(30,3),
    NomWidth Number(30,3),
    LGroups  number(11),

    Constraint FK_LbrGroup_LSizes foreign key(LGroups,LbrGroup) references LumberGroups(LGroups,LbrGroup),

    Constraint PK_LSizes primary key(LSizes,LbrGroup,LbrSize)  )
Then I execute this script for Personal Oracle 8. Table is created but there is no foreign key in it.
Please, give me a hint to correct the problem.

Gennady Received on Wed Mar 24 1999 - 17:28:19 CST

Original text of this message

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