Ugh, the text-only formatter messed that up, let's try again:
> Suggested (changes in *...*):
>
> PRAGMA database.index_xinfo(index-name);
>
> This pragma returns information about every column in an index. Unlike
> *the* index_info pragma, this pragma returns information about *all
> columns used* in the index *and not only* the key columns. (A key
> column is a column that is actually named in *the CREATE INDEX, UNIQUE
> constraint or PRIMARY KEY constraint statement which created the
> index*. Auxiliary columns are additional columns needed to locate the
> table entry that corresponds to each index entry.)
>
> Output columns from the index_xinfo pragma are as follows:
>
> 1. The rank of the column within the index. (0 means left-most. Key
> columns come before auxiliary columns.)
> 2. The rank of the column within *the table, or -1 if the column is
> the rowid of the table being indexed*.
> 3. The name of the column being indexed, or NULL *if the column is the
> rowid of the table being indexed*.
> 4. 1 if the *column is sorted in reverse order (DESC) in the index,
> or* 0 otherwise.
> 5. The name for the collating sequence used to compare values in the
> index-column.
> 6. 1 if the *column is a key column, or 0 if it is an auxiliary column*.
