[SQL] 创建数据库

-- 创建数据库, 如果存在则删除
use master
  go
  if exists(select * from sysdatabases where name='student')
  drop database student
  go
  create database student
  on
  (
  name='student_data',
  filename='student_data.mdf',
  size=10mb,
  maxsize=100mb,
  filegrowth=1mb
  )
  log on
  (
  name='student_log,
  filename='student_log.ldf',
  size=10mb,
  maxsize=100mb,
  filegrowth=1mb
  )


posted on 2018-06-26 15:31  alicegu  阅读(154)  评论(0编辑  收藏  举报