filegroupproperty-transact-sql.md

title	FILEGROUPPROPERTY (Transact-SQL) | Microsoft Docs
ms.custom
ms.date	03/03/2017
ms.prod	sql
ms.prod_service	sql-database
ms.reviewer
ms.technology	t-sql
ms.topic	language-reference
f1_keywords	FILEGROUPPROPERTY_TSQL FILEGROUPPROPERTY
dev_langs	TSQL
helpviewer_keywords	filegroups [SQL Server], property values FILEGROUPPROPERTY function viewing filegroup properties displaying filegroup properties
ms.assetid	b3a930e6-df05-4034-929c-f681f5f6fc6e
author	MikeRayMSFT
ms.author	mikeray

FILEGROUPPROPERTY (Transact-SQL)

[!INCLUDEtsql-appliesto-ss2008-xxxx-xxxx-xxx-md]

This function returns the filegroup property value for a specified name and filegroup value.

Transact-SQL Syntax Conventions

Syntax

FILEGROUPPROPERTY ( filegroup_name, property )  

Arguments

filegroup_name
An expression of type sysname that represents the filegroup name for which FILEGROUPPROPERTY returns the named property information.

property
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.

Return Types

int

Remarks

filegroup_name corresponds to the name column from the sys.filegroups catalog view.

Examples

This example returns the IsDefault property setting for the primary filegroup in the [!INCLUDEssSampleDBnormal] database.

SELECT FILEGROUPPROPERTY('PRIMARY', 'IsDefault') AS 'Default Filegroup';  
GO  

[!INCLUDEssResult]

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

See Also

FILEGROUP_ID (Transact-SQL)
FILEGROUP_NAME (Transact-SQL)
Metadata Functions (Transact-SQL)
SELECT (Transact-SQL)
sys.filegroups (Transact-SQL)