1、SQL05-数据库创建、修改、删除

create database sample           //创建数据库
on primary                       //基本文件组
(
name=sample_data,                //数据库逻辑名称
filename='d:\sample_data.mdf',   //数据库物理名称
size=5MB,                        //初始容量5MB
maxsize=50MB,                    //最大容量50MB
filegrowth=10%                   //增幅10%
)




//创建
create database business
on primary
(name=businessdat1,
filename='d:\data\businessdat1.mdf',
size=10mb,
maxsize=50mb,
filegrowth=10)
(name=businessdat2,
filename='d:\data\businessdat2.mdf',
size=10mb,
maxsize=50mb,
filegrowth=10)
filegroup business_group
(name=business_dat3,
file='d:\data\businessdat3.mdf',
size=10mb,
maxsize=50mb,
filegrowth=10%)
log on
(name=business_log,
filename='d:\data\businesslog.ldf',
size=8mb,
maxsize=100mb,
filegrowth=10mb)




//添加操作
alter database sales
add filegroup user1
add file
(name=xxx,
filename=xxx,
size=xxx,
maxsize=xxx,
filegrowth=xxx)


add log file
(name=xxx,
filename=xxx,
size=xxx,
maxsize=xxx,
filegrowth=xxx)


to filegroup user1


//删除操作
alter database sales
remove file xxx
alter database sales
remove filegroup user1




//修改数据库
alter database sales
modify file
(name=xxx,
filename=xxx,
size=xxx,
maxsize=xxx,
filegrowth=xxx)
alter database sales


alter database sales
modify name=s_ales


//重命名数据库
sp_renamedb'old_name','new_name'


//删除数据库
drop database sales