sys.filegroups

Description

Analytics Platform System (PDW) SQL database in Microsoft Fabric Contains a row for each data space that is a filegroup. For a list of columns that this view inherits, see Identified for informational purposes only. Not supported. Future compatibility is not guaranteed. In SQL Server, the value SQL Server 2016 (13.x) and later versions. 1 = When a file in the filegroup meets the autogrow threshold,

Syntax

FILEGROUP
_
ID (
'filegroup_name'
)

Permissions

Examples

Example 1

FILEGROUP_ID

Example 2

PRIMARY

Example 3

FILEGROUP
_
ID (
'filegroup_name'
)

Example 4

SELECT
FILEGROUP_ID(
'PRIMARY'
)
AS
[Filegroup
ID
];
GO

Example 5

Filegroup ID
------------
1 (1 row(s) affected)

Example 6

FILEGROUP_NAME

Example 7

1

Example 8

FILEGROUP
_
NAME ( filegroup_id )

Example 9

SELECT
FILEGROUP_NAME(1)
AS
[Filegroup
Name
];
GO

Example 10

IsDefault

(. and 4 more examples)