FILEGROWTH=512KB)
ALTER DATABASE School REMOVE FILE xxx_school_dat2
ALTER DATABASE School ADD FILE
(NAME=xxx_school_dat3,
FILENAME='d:\\sql_data1\\xxx_school_dat3.ndf', SIZE=1,
MAXSIZE=UNLIMITED, FILEGROWTH=1)
2.01..
CREATE TABLE xxx_student (
学号 char(11), 姓名 char(10), 身份证号 char(50), 籍贯 varchar(50), 家庭住址 varchar(50), 电话 char(50), 特长 varchar(50), 奖励 varchar(50),
处分 varchar(50),
CONSTRAINT pk_xh PRIMARY KEY (学号), CONSTRAINT un_xh UNIQUE (身份证号) )
2.02.
CREATE TABLE xxx_course (
课程代号 char(5), 课程名 varchar(50),
周学时 char(50) DEFAULT('3'), 学分 char(10) DEFAULT('2'),
CONSTRAINT pk_kcdh PRIMARY KEY (课程代号),
CONSTRAINT ck_ccd CHECK (课程代号 LIKE'[0-4][0-1]%') )
2.03.
create table xxx_grade (学号 char(11) not null, 课程代号 char(5) not null , 平时 int,
期中 int, 期末 int ) go
alter table xxx_grade add constraint pk_id primary key(学号) go
alter table xxx_grade add constraint fk_xh
foreign key(学号) references xxx_student(学号) on update cascade on delete cascade go
alter table xxx_grade add constraint fk_kcdh
foreign key(课程代号) references xxx_course(课程代号) on update cascade on delete cascade go
alter table xxx_grade add constraint ck_gcj