Select from following answers:- ALTER DATABASE DB1 REMOVE FILEGROUP logfile1
- ALTER DATABASE DB1 REMOVE FILE logfile1
- ALTER DATABASE DB1 MODIFY FILE (NAME=logfile1, FILEGROWTH=0MB)
- ALTER DATABASE Name1 MODIFY FILE (NAME=testfile1, SIZE=0MB)
- All Above
ALTER DATABASE <db name> REMOVE FILE <file name>
here is the syntax for removing any file from a database
Show Correct Answer
|
Alert Moderator