Re: OT: Oracle Foreign Key Constraint

2003-02-17 Thread S . Isaac Dealey
Thanks a bunch guys -- Jochem & I-Lin -- very much appreciated. :) > S. Isaac Dealey wrote: >> >> create table tship_location ( >> locationid varchar(35) primary key, >> locationname varchar(25) not null, >> locationorder int not null >> ) >> >> create table tship_xref ( >> loc

Re: OT: Oracle Foreign Key Constraint

2003-02-17 Thread I-Lin Kuo
Bad oracle syntax ALTER TABLE tship_xref ADD CONSTRAINT fk_tship_location FOREIGN KEY (locationid) REFERENCES tship_location --- "S. Isaac Dealey" <[EMAIL PROTECTED]> wrote: > I'm trying to create a foreign key constraint in > Oracle -- I have this sql > script: > > > > create table tship_loc

Re: OT: Oracle Foreign Key Constraint

2003-02-17 Thread Jochem van Dieten
S. Isaac Dealey wrote: > > create table tship_location ( > locationid varchar(35) primary key, > locationname varchar(25) not null, > locationorder int not null > ) > > create table tship_xref ( > locationid varchar(35) not null, > priceid varchar(35) not null, >

OT: Oracle Foreign Key Constraint

2003-02-17 Thread S . Isaac Dealey
I'm trying to create a foreign key constraint in Oracle -- I have this sql script: create table tship_location ( locationid varchar(35) primary key, locationname varchar(25) not null, locationorder int not null ) create table tship_pricerange ( priceid varchar(35