Is there a system table that lists all file groups?

Question

For example, master.sys.master_fileslists all files for all databases. It also displays data_space_idwhich maps to filegroups.

But the table master.sys.filegroupsonly lists the file groups used by the database master. Is there such a table where I can get all groups of files in all databases?

Answer 1

As far as I know, there is not a single table or view that shows filegroups for all the databases in the instance.

sys.filegroups, .

USE [MyDatabase]
select * from sys.filegroups