sql server 2005创建数据库示例

数据库示例代码如下

--以创建名称为Sale数据库为例

CREATE DATABASE [Sale] ON  PRIMARY 
(
NAME = N'Sale', 
FILENAME = N'C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\DATA\Sale.mdf' , 
SIZE = 3072KB , 
MAXSIZE = 102400KB , 
FILEGROWTH = 1024KB )
LOG ON 
(
NAME = N'Sale_log', 
FILENAME = N'C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\DATA\Sale_log.ldf' , 
SIZE = 1024KB , 
MAXSIZE = 51200KB , 
FILEGROWTH = 1024KB 
)
GO

数据库删除代码

USE [master]
GO
--删除名称为Sale数据库
DROP DATABASE [Sale]
GO