ALTER DATABASE 的语法结构如下所示:
ALTER DATBASE <database name>
ADD FILE
([NAME = <'logical file name'>, ]
FILENAME = <'file name'>
[, SIZE = <size in KB, MB, GB or TB>]
[, MAXSIZE = <size in KB, MB, GB or TB>]
[, FILEGROWTH = <No of KB, MB, GB or TB |percentage>]) [, ...n]
[TO FILEGROUP filegroup_name]
[, OFFLINE]
[ADD LOG FILE
([NAME = <'logical file name'>, ]
FILENAME = <'file name'>
[, SIZE = <size in KB, MB, GB or TB>]
[, MAXSIZE = <size in KB, MB, GB or TB>]
[, FILEGROWTH = <No of KB, MB, GB or TB |percentage>])
|REMOVE FILE <logical file name> [WITH DELETE]
|ADD FILEGROUP <filegroup name>
|REMOVE FILEGROUP <filegroup name>
|MODIFY FILE <filespec>
|MODIFY NAME = <new dbname>
|MODIFY FILEGROUP <filegroup name> {<filegroup property>|NAME = <new filegroup name>}
|SET <optionspec> [, ...n][WITH <termination>]
|COLLATE <collation name>
以下是一个示例,将指定的数据库扩充至100MB:
ALTER DATABASE Accounting
MODIFY FILE
(NAME = Accounting,
SIZE = 100MB)