TECHNOLOGIES
FORUMS
JOBS
BOOKS
EVENTS
INTERVIEWS
Live
MORE
LEARN
Training
CAREER
MEMBERS
VIDEOS
NEWS
BLOGS
Sign Up
Login
No unread comment.
View All Comments
No unread message.
View All Messages
No unread notification.
View All Notifications
Answers
Post
An Article
A Blog
A News
A Video
An EBook
An Interview Question
Ask Question
Forums
Monthly Leaders
Forum guidelines
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.
Reply
Answers (
1
)
Sql
Regarding Retrieving The Data from Sql