DROP TABLE Course
GO
Create table Course
(CourseNo nvarchar(10)not null constraint pk_ Course primary key,
CourseName nvarchar(30)not null,
TeacherNo nvarchar(10)not null constraint fk_Course_Teacher foreign key(TeacherNo)references Teacher(TeacherNo),
Introduction text not null ,
Hour smallint not null,
)
3)Resources表创建的SQL语句如下所述。
USE Online Learning Database