The new parameter indextype specifies an index type for all of the sp_iqcheckdb modes. The syntax is:
sp_iqcheckdb 'mode target [...] [ resources resource-percent ]'
where
mode: { allocation | check | verify } | repair
target: [ main | local | indextype index-type […] ] database | database resetclocks | { [ indextype index-type ] […] table table-name | index index-name […] }
index-type:: { FP | CMP | LF | HG | HNG | WD| DATE | TIME | DTTM }
Verify the FP and HG indexes in the table t1 and the LF indexes in the table t2.
sp_iqcheckdb 'verify indextype FP indextype HG table t1 indextype LF table t2'