IF EXISTS (SELECT *
FROM master..sysdatabases
WHERE name = 'MyDatabase')
DROP DATABASE MyDatabase
GO
USE [master]
GO
CREATE DATABASE MyDatabase
on PRIMARY
(
name = 'MyDatabase',
filename = 'd:\MyDatabase.mdf',
size = 10MB,
maxsize = UNLIMITED,
filegrowth = 1MB
)
log on
(
name='MyDatabase_log',
filename= 'd:\MyDatabase.ldf',
size=1MB,
maxsize=50MB,
filegrowth=10%
)
GO
sql 创建数据库
最新推荐文章于 2024-09-08 09:10:51 发布