createdb.sql

来自「用VC编写的立体仓库的管理软件源程序和设计说明书。」· SQL 代码 · 共 28 行

--创建名称为 'WuHan'的数据库

USE master
GO

IF exists(SELECT * FROM master..sysdatabases WHERE name='WuHan')
	DROP DATABASE WuHan
GO

CREATE DATABASE WuHan
ON(
 	NAME 		= KCB_data,
	FILENAME 	= 'D:\Manage_WH\SQL\data\WuHan.mdf',
	SIZE 		= 10MB,  
	MAXSIZE 	= 50MB,  
	FILEGROWTH	= 10MB 
   )
LOG ON( 
	NAME		= KCB_log,
	FILENAME	= 'D:\Manage_WH\SQL\data\WuHan.ldf',
	SIZE		= 10MB,  
	MAXSIZE		= 50MB,  
 	FILEGROWTH	= 10MB 
	)
GO