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, 2710🔥, 0💬
Popular Posts:
How to call JMeter command in a Windows batch file? I want to create a single batch job to run JMete...
How to call JMeter command in a Windows batch file? I want to create a single batch job to run JMete...
Why I am getting gzip compressed HTTP response in SoapUI? If you run a HTTP request for some Website...
How to convert IPv4 to IPv6 addresses? In order to help your programming or testing tasks, FYIcenter...
How to validate and decode MAC (Media Access Control) addresses? In order to help your programming o...