34,587
社区成员
发帖
与我相关
我的任务
分享
CREATE TABLE Course
(Cno CHAR(4) PRIMARY KEY,
Cname CHAR(40),
Cpno CHAR(4) FOREIGN KEY REFERENCES Course(Cno),
Ccredit SMALLINT
);
CREATE TABLE Course(
Cno CHAR(4) PRIMARY KEY,
Cname CHAR(40),
Cpno CHAR(4),
Ccredit SMALLINT
);
ALTER TABLE Course ADD CONSTRAINT
FK_Course_Course FOREIGN KEY
(
Cpno
) REFERENCES dbo.Course
(
Cno
)
ON UPDATE NO ACTION
ON DELETE NO ACTION