Cry How to...

List all filegroups

To get a list of all the filegroups, use:

select groupname from sysfilegroups

These notes have been tested against SQL Server 7.

About the author: is a dedicated software developer and webmaster. For his day job he develops websites and desktop applications as well as providing IT services. He moonlights as a technical author and consultant.