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
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,
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 (
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)
4 matches
Mail list logo