DBCC IND

The DBCC IND statement takes three parameters like this:

DBCC IND(0,'dbo.SalesOrderDetailList',1);

First parameter is the database id. If you pass in 0 here, the current database is used.

Second parameter is the table name in quotes. You can also pass in the object_id of the table instead of the quoted name like this:

DBCC IND(0,1797581442,1);

Third parameter is the index_id. There is an optional fourth parameter that allows us to specify the partition_id if we are only interested in a single partition.

DBCC IND(0,'dbo.SalesOrderDetailList',1);