Fiston

Fiston

  • NA
  • 30
  • 26k

Creating Foreign key error

Sep 21 2009 5:24 PM
Hi, I'm trying to refers two columns of this table create table passenger ( PNR_NO char (8) primary key, FLIGHT_NO char(5) constraint fk_flight foreign key references flight (FLIGHT_NO) not null, TRAVEL_DATE date constraint fk_travel_date foreign key references flight (flight_date) not null, FIRST_NAME varchar(20) not null, LAST_NAME varchar(20) not null, AGE int not null, GENDER char(1) not null, CLASS char(1) not null, MEAL_PREF char(1) not null, SSR varchar(150) not null, STATUSS char (1), CANCEL_FLAG char(1) not null, PHOTO image not null ) with two of a composite key fails create table flight( FLIGHT_NO char(5), FLIGHT_DATE date, DEP_TIME time not null, ARR_TIME time not null, AIRCRAFT_ID char (4) constraint fk Foreign key references aircraft (AIRCRAFT_ID) not null, FIRST_CLASS_SEATS int not null, BUSINESS_CLASS_SEATS int not null, ECO_CLASS_SEATS int not null, constraint pk primary key (FLIGHT_NO, FLIGHT_DATE) ) i'm getting this ERROR : Msg 1776, Level 16, State 0, Line 1 There are no primary or candidate keys in the referenced table 'flight' that match the referencing column list in the foreign key 'fk_flight'. Msg 1750, Level 16, State 0, Line 1 Could not create constraint. See previous errors.

Answers (1)