Jasinski Technical Wiki

Navigation

Home Page
Index
All Pages

Quick Search
»
Advanced Search »

Contributor Links

Create a new Page
Administration
File Management
Login/Logout
Your Profile

Other Wiki Sections

Software

PoweredBy

sysfilegroups System Table - SQL Server 2000

RSS
Modified on Fri, May 01, 2009, 10:54 AM by Administrator Categorized as SQL Server System Tables
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 nameData typeDescription
groupidsmallintGroup identification number unique for each database.
allocpolicysmallintReserved.
statusint0x8 = READ ONLY; 0x10 = DEFAULT
groupnamesysnameName of the filegroup.

ScrewTurn Wiki version 3.0.1.400. Some of the icons created by FamFamFam. Except where noted, all contents Copyright © 1999-2024, Patrick Jasinski.