I am new to SQL and I am trying to create the table for itinerary items however keep getting the same error message that I am “missing a keyword”. I have tried looking it up for what is wrong however I can not find anything
Any solution or if you have any design suggestions to this would be much appreciated!
create table itinerary_item ( tour_id varchar(8) , location_id varchar(8) , order_visited_number varchar(8) , primary key (tour_id, location_id) , foreign key (tour_id) references tour(tour_id) , foreign key (location_id) location(location_id) );
Advertisement
Answer
Hi please use references keyword at the last line of your sql table creation script!!!