增:
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
SQL server 增、删、改代码
最新推荐文章于 2021-11-24 23:24:09 发布