2. 使用ALTER DATABASE语句修改数据库
例4-3　将两个数据文件和一个事务日志文件添加到test数据库中。
程序清单如下：
ALTER DATABASE Test
ADD FILE
(NAME = Test1, FILENAME='c:\Program Files\Microsoft SQL Server\MSSQL\Data\test1.ndf', SIZE =

5MB, MAXSIZE = 100MB, FILEGROWTH = 5MB),
(NAME = Test2, FILENAME='c:\Program Files\Microsoft SQL Server\MSSQL\Data\test2.ndf', SIZE =

3MB, MAXSIZE = 10MB, FILEGROWTH = 1MB)
GO
ALTER DATABASE Test
 ADD LOG FILE ( NAME = testlog1, FILENAME='c:\Program Files\Microsoft SQL

Server\MSSQL\Data\testlog1.ldf',  SIZE = 5MB,  MAXSIZE = 100MB,  FILEGROWTH = 5MB)
GO

3、重命名test为demo
  sp_renamedb 'test','demo'

4、删除数据库
  drop database demo
本文出自 51CTO.COM技术博客