ADD FILE
ALTER DATABASE First ADD FILE ( NAME = First_App, FILENAME = 'D:\First_App.ndf', SIZE = 10, MAXSIZE = 500, FILEGROWTH = 10)ADD LOG FILE
ALTER DATABASE First ADD LOG FILE ( NAME = First_Bpp, FILENAME = 'D:\First_Bpp.ldf', SIZE = 5, MAXSIZE = 500, FILEGROWTH = 5)REMOVE FILE
ALTER DATA First REMOVE FILE First_AppMODIFY FILE
ALTER DATABASE First MODIFY FILE ( NAME = First_BPP, FILEGROWTH = 10)ADD FILEGROUP
REMOVE FILEGROUP
MODIFY FILEGROUP
ALTER DATABASE命令只有DBA数据库管理员或者具有CERATE DATABASE的权限的数据库的所有者才有权执行此命令