FILEGROUPPROPERTY (Transact-SQL)
Returns the specified filegroup property value when supplied with a filegroup and property name.
This example returns the setting for the IsDefault property for the primary filegroup in the AdventureWorks database.
USE AdventureWorks;
GO
SELECT FILEGROUPPROPERTY('PRIMARY', 'IsDefault') AS 'Default Filegroup';
GO
Here is the result set.
Default Filegroup --------------------- 1 (1 row(s) affected)
