S2 优化数据库设计 第二章上级

USE master
GO
IF EXISTS(SELECT * FROM sysdatabases WHERE name='MySchool1')  --判断
DROP DATABASE MySchool1   --删除语句
CREATE DATABASE MySchool1  --执行
ON  (
NAME='MySchool10.mdf',    --逻辑名称
FILENAME='F:\vis\MySchool10.mdf',   --物理名称
SIZE=10,   --初始大小
FILEGROWTH=20%   --增长率
),(
NAME='MySchool10.ndf',
FILENAME='F:\vis\MySchool10.ndf',
SIZE=10,
FILEGROWTH=20%
)LOG ON(
NAME='MySchool1_log',
FILENAME='F:\vis\MySchool1log_log.ldf',
SIZE=3,
MAXSIZE=20,  --增长的最大值
FILEGROWTH=1
),(
NAME='MySchool2_log',
FILENAME='F:\vis\MySchool2log_log.ldf',
SIZE=3,
MAXSIZE=20,
FILEGROWTH=1
)


USE  MySchool1 
IF EXISTS(SELECT * FROM sysobjects WHERE NAME='kecheng')  --判断
DROP TABLE kecheng         --删除
CREATE TABLE kecheng(       --创建
SubjectName nvarchar(50),
ClassHour int,
GradeID int
)
ALTER TABLE kecheng
ADD SubjectNo int