IF exists (select * from sysdatabases where name='MySchool')
DROP DATABASE MySchool
create database MySchool
on primary
(
--主数据文件的具体描述
NAME='MySchool',
FILENAME='F:\数据库\MySchool.mdf',
SIZE=10MB,
FILEGROWTH=20%
)
log on
(
--日志文件1的具体描述
NAME='MySchool_Log',
FILENAME='F:\数据库\MySchool.ldf',
SIZE=3MB,
FILEGROWTH=1MB,
MAXSIZE=20MB
)
use MySchool
GO
--检查,判断课程表Subject是否存在,若存在,则删除
if exists (select * from sysobjects where name='Subject')
DROP TABLE Subject
--创建Subject课程表
create table Subject
(
SubjectNo int not null identity(1,1),
SubjectName nvarchar(50) not null,
ClassHour int
DROP DATABASE MySchool
create database MySchool
on primary
(
--主数据文件的具体描述
NAME='MySchool',
FILENAME='F:\数据库\MySchool.mdf',
SIZE=10MB,
FILEGROWTH=20%
)
log on
(
--日志文件1的具体描述
NAME='MySchool_Log',
FILENAME='F:\数据库\MySchool.ldf',
SIZE=3MB,
FILEGROWTH=1MB,
MAXSIZE=20MB
)
use MySchool
GO
--检查,判断课程表Subject是否存在,若存在,则删除
if exists (select * from sysobjects where name='Subject')
DROP TABLE Subject
--创建Subject课程表
create table Subject
(
SubjectNo int not null identity(1,1),
SubjectName nvarchar(50) not null,
ClassHour int