(TeacherNO nvarchar (10) not null constraint pk_ Teacher primary key,
TeacherName nvarchar (30) not null,
Sex nvarchar (10) not null,
Birthday date,
College nvarchar(10)not null,
CourseNo nvarchar (10) not null constraint fk_
Teacher_Course foreign key(CourseNO)references Course(CourseNO)
)
2)Course表创建的SQL语句如下所述。
USE Online Learning Database
IF EXISTS(SELECT*FROM sysobjects WHERE NAME=´ Course´ and TYPE=´U´)