一、T-SQL创建XS数据库(database)
create database XS
on
( name = xs_dat,
filename = 'D:\数据库复习\xd_dat.mdf',
size = 20 mb,
filegrowth = 1mb
),
(
name = xs_dat2,
filename = 'D:\数据库复习\xd_dat.ndf',
size = 10 mb,
filegrowth = 10%
)
log on
(
name = xs_log,
filename = 'D:\数据库复习\xd_log.ldf',
size = 1,
filegrowth = 10%
)
二、T-SQL管理XS数据库(查看、修改、缩小、重命名、删除数据库)
2.1、T-SQL查看(sp_helpdb)XS数据库信息
sp_helpdb xs
sp_helpdb
2.2、T-SQL修改(alter)XS数据库信息
alter database xs
add file
(
name = xs_dat3,
filename = 'E:\data\xs_dat3.ndf',
size = 6,
filegrowth = 10
)
alter database xs
modify file (name = xs_dat3,size = 7)
modify file (name = xs_log,size = 2)
DBCC shrinkfile (xs_dat3,4)
alter database xs
add file
(
name = xs_log2,
filename = 'E:\data\xs_log2.ldf',