Altering a Database : Alter Database « Database « SQL Server / T-SQL Tutorial

1. SQL Server / T-SQL Tutorial
2. Database
3. Alter Database

ALTER DATABASE db_name
  ADD FILE file_spec1 [TO FILEGROUP group_name1]
  |ADD LOG FILE file_spec2
  |REMOVE FILE 'file_name'
  |MODIFY FILE (NAME = old_name, NEWNAME = new_name ...)
  |CREATE FILEGROUP group_name2 | DROP FILEGROUP filegroup_name3
  |SET option_specifications [WITH terminations]

13> create database projects;
14>
15> ALTER DATABASE projects
16>       ADD FILE (NAME=projects_dat1,
17>         FILENAME = 'C:\DATA\projects1.mdf',
18>         SIZE = 10,
19>         MAXSIZE = 100,
20>         FILEGROWTH = 5)
21>
22> drop database projects;
23> GO