sys.sysfilegroups

Description

Contains one row for each file group in a database. There is at least one entry in this table that is for the primary file group. Group identification number unique for each database. Mapping System Tables to System Views (Transact-SQL) Compatibility Views (Transact-SQL) This SQL Server 2000 system table is included as a view for backward compatibility. We recommend that you use the current SQL Server system views instead.