SQL Server创建数据库的命令用法详细说明

这篇文章主要为大家详细介绍了SQL Server创建数据库的命令用法示例，具有一定的参考价值，可以用来参考一下。

-- =============================================  
-- Basic Create Database Template  
-- 512笔记：www.512pic.com
-- =============================================  
IF EXISTS (SELECT *   
    FROM   master..sysdatabases   
    WHERE name = N'suntest')  
DROP DATABASE suntest  
GO  
 
CREATE DATABASE suntest  
on  
primary  
(  
name = suntest_data,  
filename = 'e:\suntest_data.mdf',  
size = 3,  
maxsize = 10,  
filegrowth = 10%   
),  
filegroup newgroup1  
(  
name = suntest_data,  
filename = 'e:\suntest_data.mdf',  
size = 3,  
maxsize = 10,  
filegrowth = 1 
)  
log on  
(  
name=suntest_log,  
filename='e:\suntest_log.mdf',  
size=1,  
maxsize=6,  
filegrowth=1 
)  
GO  

注：关于SQL Server创建数据库的命令用法示例的内容就先介绍到这里，更多相关文章的可以留意