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

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,

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_location (

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 ( locationid varchar(35)