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, 2318🔥, 0💬
Popular Posts:
How to turn on Chrome WebDriver logging with Selenium Python API? If you want to turn on logging on ...
How to generate currency test values? Currency test values are frequently needed in testing date and...
How to find out my browser's identification information? To help you to see your browser identificat...
How to generate MAC addresses? To help you to obtain some MAC addresses for testing purpose, FYIcent...
Why I am getting gzip compressed HTTP response in SoapUI? If you run a HTTP request for some Website...