创建数据库、文件组、删除数据库

--1.创建数据库
use master
go
create database db_Test
on primary
(
Name = 'DB_Test',
FileName = 'F:\测试文件夹\DB_Test_data.mdf',
Size = 10MB,
MaxSize = 100MB,
FileGrowth = 10%
)
Log on
(
Name = 'DB_Test_Log',
FileName = 'F:\测试文件夹\DB_test_log.ldf'
)
Go
select * from sysdatabases  --查看所有的数据库


--2.添加文件组
use db_Test
alter database db_Test Add FileGroup FileGroup2
Go
alter database db_Test add File
(
Name = 'FileGroup2_db_Test_data',
FileName = 'F:\测试文件夹\FileGroup2_db_Test_data.ndf',
Size = 3MB,
FileGrowth = 20%
)To FileGroup FileGroup2
Go
Alter database db_Test
modify FileGroup FileGroup2 default
--3.删除数据库
use master
if exists(select * from sysdatabases where name= 'db_Test')
drop database db_Test