--ignore start
--====================创建数据库(START)====================
USE master --转到master数据库
GO
--DROP DATABASE OCFA2
IF NOT EXISTS (SELECT * FROM master.dbo.sysdatabases WHERE name='OCFA2') --开始创建数据库
BEGIN
CREATE DATABASE OCFA2
ON --创建数据文件
(
NAME = OCFA2_Data,
FILENAME = 'D:\Database\OCFA2_Data.MDF',
SIZE = 3MB,
FILEGROWTH = 10%
)
LOG ON --创建日志文件
(
NAME = OCFA2_Log,
FILENAME = 'D:\Database\OCFA2_Log.LDF',
SIZE = 1MB,
FILEGROWTH = 10%
)
RAISERROR ('数据库[OCFA2]创建成功',0,1) WITH NOWAIT
END
GO
CHECKPOINT
--====================创建数据库(END)====================