SQL 中 ALTER DATABAES 语句的语法结构

    <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)