创建数据库与查询数据库

–创建数据库
create database db_student
on primary(
name=db_studentn,
filename=‘D:\data\db_student.mdf’,
size=5,
maxsize=unlimited,
filegrowth=1
)
log on(
name=db_student,
filename=‘D:\data\db_student.ldf’,
size=1,
maxsize=5,
filegrowth=10%
)
alter database db_student
add file --添加辅数据文件
(
name=db_studentfu,
filename=‘d:\data\db_studentfu.ndf’,
size=1,
maxsize=unlimited,
filegrowth=20%
)
–查看服务其所有的数据库
Execute sp_helpdb
–查看某一数据库信息
exec sp_helpdb db_student
–重命名数据库
execute sp_renamedb db_student,db_s
–修改数据
–修改数据库每修改一次都要添加alter database db_s
alter database db_s
add file --添加数据文件
(
name=db_s,
filename=‘d:\data\db_s.ndf’,
size=6,
maxsize=unlimited,
filegrowth=10%
)
alter database db_s
add log file( --添加日志文件
name=db_s_log,
filename=‘d:\data\db_s_log.ldf’
)
alter database db_s
modify file --修改指定的文件属性
(
name=db_s,
size=10,
filegrowth=2
)

–删除文件
alter database db_s
remove file db_s_log --删除文件

–添加文件组
alter database db_s
add filegroup g --添加文件组

alter database db_s --添加文件到指定文件组中
add file (
name=db_s1,
filename=‘d:\data\db_s1.ndf’
)to filegroup g

–删除文件分别进行
alter database db_s
remove file db_s
alter database db_s
remove file db_s1

–删除数据库
drop database db_tsjyy,db_studentnew

–分离数据库
exec sp_detach_db db_s
–附加数据库
exec sp_attach_db db_student ,‘d:\data\db_student.mdf’