IF EXISTS(SELECT*FROM sysobjects WHERE NAME=´ Resources´ and TYPE=´U´)
DROP TABLE Resources
GO
Create table Resources
(ResourceNO nvarchar(10)not null constraint pk_ Resources primary key,
ResourceName nvarchar(30)not null ,
CourseNO nvarchar(10)not null constraint fk_
Resources_Course foreign key(CourseNO) references Course(CourseNO),
ResourceType nvarchar(10)not null,
ChapterNO nvarchar(10)not null,
)