How can I check..

I have one database file in separate filegroup. I can't delete this file
because it is not empty.
How can I check which table is a part of this database file ?select id, object_name(id) as 'Object', indid, name, s.groupid, fg.groupname
from sysindexes s inner join sysfilegroups fg
on s.groupid = fg.groupid
you can also put a where fg.groupname = 'myfilegroup'
to see only the objects on a particular FG
--
Wayne Snyder, MCDBA, SQL Server MVP
Mariner, Charlotte, NC
www.mariner-usa.com
(Please respond only to the newsgroups.)
I support the Professional Association of SQL Server (PASS) and it's
community of SQL Server professionals.
www.sqlpass.org
"MK" <MK@.discussions.microsoft.com> wrote in message
news:FEC364E9-20CE-468B-A961-E56D70508032@.microsoft.com...
> I have one database file in separate filegroup. I can't delete this file
> because it is not empty.
> How can I check which table is a part of this database file ?