Rabu, 02 Desember 2015

Query : Create Table with Foreign Key

example

create table exams
(
    exam_id uniqueidentifier primary key,
    exam_name varchar(50),
);
 
create table question_bank
(
    question_id uniqueidentifier primary key,
    question_exam_id uniqueidentifier not null,
    question_text varchar(1024) not null,
    question_point_value decimal,
    foreign key ( question_exam_id ) references exams (exam_id)
);
 

Tidak ada komentar:

Posting Komentar