Database Study Notes (3), Database Study Notes

Database Study Notes (3), Database Study Notes

Tip:

To run a program, you must first add the database to the specified folder,

For example, if E: \ DATA is written in the code, you must first create a folder in E: \, and then compile and execute the database code.

-- Add studentfgrp file groups to the database, and add studentfile. ndf to studentfgrp.
Alter DATABASE student
Add filegroup studentfgrp
GO
Alter database student
ADD FILE
(
NAME = 'studentfile ',
FILENAME = 'e: \ DATA \ studentfile. ndf'
)
To filegroup studentfgrp
GO