Export (0) Print
Expand All
Expand Minimize

sysfilegroups

SQL Server 2000

Contains one row for each filegroup in a database. This table is stored in each database. There is at least one entry in this table that is for the primary filegroup.

Column name Data type Description
groupid smallint Group identification number unique for each database.
allocpolicy smallint Reserved.
status int 0x8 = READ ONLY
0x10 = DEFAULT
groupname sysname Name of the filegroup.

Was this page helpful?
(1500 characters remaining)
Thank you for your feedback
Show:
© 2014 Microsoft