Introduction - If you have any usage issues, please Google them yourself
If exists(select name from sysobjects where name="Score" and type="U")
Drop table Score
go
create table Score(
UserName varchar(10) not null,
Subject varchar(15) not null,
Score int
)
go
If exists(select name from sysobjects where name="Subject" and type="U")
Drop table Subject
go
create table Subject(
UserName varchar(10) not null,
Subject varchar(15) not null,
Term varchar(10) not null
)
go