| title | FILEGROUPPROPERTY (Transact-SQL) | ||||
|---|---|---|---|---|---|
| description | FILEGROUPPROPERTY returns the filegroup property value for a specified name and filegroup value. | ||||
| author | markingmyname | ||||
| ms.author | maghan | ||||
| ms.reviewer | randolphwest | ||||
| ms.date | 06/05/2025 | ||||
| ms.service | sql | ||||
| ms.subservice | t-sql | ||||
| ms.topic | reference | ||||
| f1_keywords |
|
||||
| helpviewer_keywords |
|
||||
| dev_langs |
|
[!INCLUDE SQL Server Azure SQL Managed Instance]
This function returns the filegroup property value for a specified name and filegroup value.
:::image type="icon" source="../../includes/media/topic-link-icon.svg" border="false"::: Transact-SQL syntax conventions
FILEGROUPPROPERTY ( filegroup_name , property )
An expression of type sysname that represents the filegroup name for which FILEGROUPPROPERTY returns the named property information.
An expression of type varchar(128) that returns the name of the filegroup property. Property can return one of these values:
| Value | Description | Value returned |
|---|---|---|
IsReadOnly |
Filegroup is read-only. | 1 = TRUE 0 = FALSE NULL = Invalid input. |
IsUserDefinedFG |
Filegroup is a user-defined filegroup. | 1 = TRUE 0 = FALSE NULL = Invalid input. |
IsDefault |
Filegroup is the default filegroup. | 1 = TRUE 0 = FALSE NULL = Invalid input. |
int
filegroup_name corresponds to the name column from the sys.filegroups catalog view.
This example returns the IsDefault property setting for the primary filegroup in the [!INCLUDE sssampledbobject-md] database.
SELECT FILEGROUPPROPERTY('PRIMARY', 'IsDefault') AS 'Default Filegroup';
GO[!INCLUDE ssResult]
Default Filegroup
---------------------
1