create database nn
create database jx
on primary
(name=jx1,
filename='d:\jx1.mdf',
size=10,
maxsize=100,
filegrowth=2),
(name=jx2,
filename='d:\jx2.ndf')
log on
(name=jx1_log,
filename='d:\jx1_log.ldf')
create database cs
on primary
(name=cs1,
filename='d:\cs1.mdf'),
filegroup csg
(name=cs2,
filename='d:\cs2.ndf')
修改数据库(alter)
1.给jx 数据库添加一个数据文件jx3
alter database jx
add file
(name=jx3,
filename='d:\jx3.ndf',
size=10,
maxsize=unlimited,
filegrowth=20%)
2.给jx数据库添加日志文件jx2_log
alter database jx
add log file
(name=jx2_log,
filename='d:\jx2_log')
3.给jx数据库添加文件组jxg
alter database jx
add filegroup jxg
4.给jx数据库jxg文件组添加文件jx4
alter database jx
add file
(name=jx4,
filename='d:\jx4.ndf') to filegroup jxg
5.删除数据文件jx3,jx2,问jx1能否删除(remove)
alter database jx remove file jx4
6.删除文件组jxg,问主文件组能否删除
alter database jx
remove filegroup jxg
drop database jx use nn
create table s
(sno char(8) constraint sno_p primary key,
sn varchar(10) not null,
sex char(2) default '男',
age tinyint,
dept varchar(50) )
create table c
(cno char(10) primary key,
cn varchar(50))
create table sc
(sno char(8) not null foreign key references s(sno),
cno char(10) not null foreign key references c(cno),
score numeric(4,1) check(score>=0 and score<=100),
primary key(sno,cno))