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.