Whether an index on a base table is integrated or not is reported in the INTEGRATED column of the INDEXES schema rowset (see "Schema Rowsets" later in this chapter).
You can obtain integrated index behavior by opening a rowset on an integrated index—that is, passing valid table and index IDs to OpenRowset. In this case, the consumer deals with a single rowset to read the data in index order, to have access to all base table columns, and to update both the base table and associated index based on calls to IRowsetChange on the rowset.