<p>ALTER DATABASE 的语法结构如下所示:</p>
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)