Wednesday, May 04, 2005

I was trying to determine whether I had put all of my tables on the correct filegroup and I wanted to list this. I came up with the following query to quickly list all the needed information.

SELECT o.Name as 'Table Name', g.GroupName
FROM sysobjects o
JOIN sysindexes i on =
JOIN sysfilegroups g on g.groupid = i.groupid

No comments: