Hi to all!!

How can I list all the tables per filegroup?.

Each time I create a table I can specify on which filegroup it'll be placed, but, once they're created the only way I know to determine in which filegroup is a table is by opening it in design mode in the enterprise manager.

What I need is to build a store procedure or a query that lists all the tables included in a filegroup or at least a physical data file.

Thanks in advance.