Returns the names and attributes of filegroups associated with the current database.
sp_helpfilegroup [[@filegroupname =] 'name']
0 (success) or 1 (failure)
Column name | Data type | Description |
---|---|---|
name | sysname | Name of the file group |
groupid | smallint | Numeric group identifier |
filecount | integer | Number of files in the file group |
Execute permission defaults to the public role.
This example returns information about the filegroups in pubs.
USE pubs
EXEC sp_helpfilegroup
sp_attach_db | sp_helpfile |
sp_attach_single_file_db | System Stored Procedures |
sp_detach_db |