创建SQL 数据库的通用脚本

USE master
GO

-- Drop the database if it already exists

/* one method
IF DB_ID (N'DemoDb') IS NOT NULL
DROP DATABASE DemoDb
GO
*/

IF  EXISTS (
    SELECT name 
        FROM sys.databases 
        WHERE name = N'DemoDb'
)
DROP DATABASE [DemoDb]
GO

-- Get the SQL Server data path
DECLARE @data_path nvarchar(256)
SET @data_path = (SELECT SUBSTRING(physical_name, 1, CHARINDEX(N'master.mdf', LOWER(physical_name)) - 1)
                  FROM master.sys.master_files
                  WHERE database_id = 1 AND file_id = 1)
--Create the DataBase
EXECUTE
('
  CREATE DATABASE [DemoDb] ON  PRIMARY 
  (NAME = NewsDb, 
  FILENAME = '''+ @data_path + 'DemoDb.mdf'', 
  SIZE = 3072KB , 
  MAXSIZE = UNLIMITED, 
  FILEGROWTH = 1024KB)
 LOG ON 
 (NAME = NewsDb_log,
  FILENAME = '''+ @data_path + 'DemoDb_Log.ldf'', 
  SIZE = 1024KB ,
  MAXSIZE = 2048GB , 
  FILEGROWTH = 10%)
')
GO

USE DemoDb
GO

--Create the Table