SQL server 增、删、改代码

增：

use master
go
alter database EMIS301
add file
( name='emis301_data',
 filename='D:\Database301\emis301_data.ndf',
 size=5MB,
 maxsize=100MB,
 filegrowth=5MB
)
go

———————————————————————————————————————————
改：

alter database EMIS301
modify file
(
 name='emis301_data',
 filename='.ndf',
 size = 8Mb,
 maxsize=150Mb,
 filegrowth=
)
go


———————————————————————————————————————————
删：
alter database EMIS301
remove file emis301_data
go