sysallocations (T-SQL)

Contains a row for each allocation unit. This table is stored in each database.

Column name Data Type Description
objid int Object identification number.
indid smallint Index identification number.
fileid smallint File identification number.
gaminterval int Interval used for the global allocation map (GAM). For more information, see Space Allocation and Reuse.
iampage binary(6) Index allocation map. For more information, see Space Allocation and Reuse.

  


(c) 1988-98 Microsoft Corporation. All Rights Reserved.