创建customers数据库示例.sql

来自「SQL基础教程上的一些源码」· SQL 代码 · 共 32 行

CREATE DATABASE Customers 
ON PRIMARY 
(
   NAME = Customers,
	   FILENAME = 'C:\Program Files\Microsoft SQL Server\ MSSQL.1\MSSQL\DATA\ Customers.mdf',
	SIZE = 10, 
	MAXSIZE = UNLIMITED, 
	FILEGROWTH = 2
),
FILEGROUP DefaultGroup
( 
	NAME = Customers_1, 
FILENAME = 'C:\Program Files\Microsoft SQL Server\ MSSQL.1\ MSSQL\DATA\ Customers_1.ndf', 
	SIZE = 3MB, 
	MAXSIZE = UNLIMITED, 
	FILEGROWTH = 1MB
)
LOG ON 
( 
	NAME = Customers_log, 
	FILENAME = 'D:\DataBaseLog \Customers_log.ldf', 
	SIZE = 1MB, 
	MAXSIZE = UNLIMITED, 
	FILEGROWTH = 10% 
),
( 
	NAME = Customers_log1, 
	FILENAME = 'D:\DataBaseLog\Customers_log1.ldf', 
	SIZE =3MB, 
	MAXSIZE = UNLIMITED, 
	FILEGROWTH = 10% 
)