SQLServer数据库创建

--------------------------------
--若存在同名数据库，则删除数据库
USE master
IF EXISTS(SELECT * from sysdatabases WHERE name='Market')
DROP DATABASE Market
GO
--------------------------------
--创建数据库
--------------------------------
CREATE DATABASE Market

ON PRIMARY--主文件组
(
	NAME='Market_data.mdf',
	FILENAME='D:\SQLProject\Market_data.mdf',
	SIZE=5MB,
	FILEGROWTH=10%,
	MAXSIZE=100MB
),
FILEGROUP FG--文件组
(
	NAME='FG_Market.ndf',
	FILENAME='D:\SQLProject\Market_data.ndf',
	SIZE=10MB,
	FILEGROWTH=10%,
	MAXSIZE=100MB
)

LOG ON--日志
(
	NAME='Market_log.ldf',
	FILENAME='D:\SQLProject\Market_log.ldf',
	SIZE=2MB,
	FILEGROWTH=0
),
(
	NAME='Market2_log.ldf',
	FILENAME='D:\SQLProject\Market2_log.ldf',
	SIZE=5MB,
	FILEGROWTH=0
)
GO
-----------------------------------

-----------------------------------
--设置默认文件组
ALTER DATABASE Market
MODIFY FILEGROUP FG DEFAULT
GO
-----------------------------------

-----------------------------------
--查询所有数据库
SELECT * FROM sysdatabases
GO
-----------------------------------

-----------------------------------
--对数据库做局部修改
--增加一个文件组
USE Market
ALTER DATABASE Market ADD FILEGROUP FG2
GO

ALTER DATABASE Market ADD FILE
(
	NAME='FG2_Market_data.ndf',
	FILENAME='D:\SQLProject\FG2_Market_data.ndf',
	SIZE=10MB,
	FILEGROWTH=10%,
	MAXSIZE=100MB
)TO FILEGROUP FG2

GO
------------------------------------