Is there a system table that lists all file groups?

Viewed 1281

For example master.sys.master_files lists all files for all databases. It also lists data_space_id which maps to the file groups.

But the master.sys.filegroups table only lists file groups used by the master database. Is there such a table where I can get all file groups across all databases?

1 Answers
Related