我从来没有为SQL Server"手工编码"过对象创建代码,而SQL Server和Postgres之间的外键删除似乎有所不同.以下是我迄今为止的sql:
drop table exams;
drop table question_bank;
drop table anwser_bank;
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,
constraint question_exam_id foreign key references exams(exam_id)
);
create table anwser_bank
(
anwser_id uniqueidentifier primary key,
anwser_question_id uniqueidentifier,
anwser_text varchar(1024),
anwser_is_correct bit
);
运行查询时,会出现以下错误:
Msg 8139,16级,状态0,第9行
你能发现错误吗?