当前位置：首页 > 数据库 > MSSQL教程 > SQL Server中的dbcc ind命令用法 > 正文

SQL Server中的dbcc ind命令用法

来源：这里教程网 时间：2026-03-02 10:00:28 作者：

DBCC IND has three parameters. The first parameter is the database name or the database ID. The second parameter is the object name or object ID within the database. The third parameter is a specific index ID or one of the values 0, -1, or −2.

Here's the syntax:

DBCC IND ({'dbname' | dbid }, { 
'objname' | objid }, { indid | 0 | -1 | -2 })
  0Displays the page numbers for all IAMs and data pages.
-1Displays the page numbers for all IAMs, data pages, and index pages.
-2Displays the page numbers for all IAMs.
indidDisplays the page numbers for all IAMs and index pages for this index. If the index ID is 1 (meaning the clustered index), the data pages are also displayed.

The columns mean:

PageFID - the file ID of the page
PagePID - the page number in the file
IAMFID - the file ID of the IAM page that maps this page (this will be NULL for IAM pages themselves as they're not self-referential)
IAMPID - the page number in the file of the IAM page that maps this page
ObjectID - the ID of the object this page is part of
IndexID - the ID of the index this page is part of
PartitionNumber - the partition number (as defined by the partitioning scheme for the index) of the partition this page is part of
PartitionID - the internal ID of the partition this page is part of
iam_chain_type - see IAM chains and allocation units in SQL Server 2005
PageType - the page type. Some common ones are:
1 - data page
2 - index page
3 and 4 - text pages
8 - GAM page
9 - SGAM page
10 - IAM page
11 - PFS page
IndexLevel - what level the page is at in the index (if at all). Remember that index levels go from 0 at the leaf to N at the root page (except in clustered indexes in SQL Server 2000 and 7.0 - where there's a 0 at the leaf level (data pages) and a 0 at the next level up (first level of index pages))
NextPageFID and NextPagePID - the page ID of the next page in the doubly-linked list of pages at this level of the index
PrevPageFID and PrevPagePID - the page ID of the previous page in the doubly-linked list of pages at this level of the index[@more@]

编辑推荐：

相关推荐

最新软件资讯

AutoCAD中式建筑模型烛台的画法
AutoCAD中式建筑模型烛台的画法

热文推荐

天极热推