sql server 创建数据库标准脚本

use master

go

if exists(select * from sysdatabases where name='TEST_DB')

drop database TEST_DB

go

create database TEST_Db

on primary

(

   name='TEST_DB_data',

   filename='C:\DB\TestDB\TEST_DB_data.mdf',

   size=10MB,

   filegrowth=5MB

)

log on

(

   name='TEST_DB_log',

   filename='C:\DB\TestDB\TEST_DB_log.ldf',

   size=5MB,

   filegrowth=2MB

)

go