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