SQL入门(创建数据库语法)

use master 
go
--判断是否存在Bank_ATM
if exists (select * from sysdatabases where name='Bank_ATM')
drop database Bank_ATM


--创建BANK_ATM数据库
create database Bank_ATM
ON PRIMARY 
(
--主数据库文件的描述
NAME ='BANK_ATM1',
FILENAME ='E:\Project\BANK_ATM1.MDF',
SIZE = 10,
FILEGROWTH =10% 
),
(
--创建次要数据文件
NAME ='BANK_ATM2',
FILENAME ='E:\Project\BANK_ATM2.ndf',
SIZE = 5,
MAXSIZE = 100,
FILEGROWTH =1
)
LOG ON 
(
--创建日志文件
NAME ='BANK_ATM3',
FILENAME ='E:\Project\BANK_ATM3.ldf',
SIZE = 10,
MAXSIZE = 50,
FILEGROWTH =1
)
GO