Collections:
What Is sys.filegroups?
What Is sys.filegroups view in SQL Server?
✍: FYIcenter.com
sys.filegroups is a system view in a SQL Server Database that contains information about each logical filegroups used by the database.
Each record in the sys.filegroups table represents a single SQL Server Logical Filegroup with the following key fields:
Here is an example of SQL Server Database with only 1 required default filegroup:
SELECT * FROM sys.filegroups name data_space_id type type_desc is_default is_system ... DEFAULT 1 FG ROWS_FILEGROUP 1 0 ...
⇒ List All Files in a Filegroup
⇐ What Is a SQL Server Filegroup
2019-07-14, 2241🔥, 0💬
Popular Posts:
How to valid IP addresses? In order to help your programming or testing tasks, FYIcenter.com has des...
How to turn off HTTP response compression in SoapUI? HTTP response compression reduces the data size...
How to perform UUDecode (Unix-to-Unix Decode)? UUEncode is Unix-to-Unix encoding used on Unix system...
How to generate email addresses? To help you to obtain some email addresses for testing purpose, FYI...
How to turn on Chrome WebDriver logging with Selenium Python API? If you want to turn on logging on ...