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, 2233🔥, 0💬
Popular Posts:
How to turn off HTTP response compression in SoapUI? HTTP response compression reduces the data size...
How to perform regular expression pattern match with multiple occurrences? To perform a regular expr...
How to use HTTP protocol to post an XML message to a server? You can follow this tutorial to post an...
How to perform UUDecode (Unix-to-Unix Decode)? UUEncode is Unix-to-Unix encoding used on Unix system...
What are JMeter command line options? You can get see JMeter command line options by running this co...