Show MySQL index?

[wmgilligan]

Anyone know how to do something like this:

<MvOpenView name="data" view="keycheck" QUERY="{ 'show index from thisTable where Column_name=\'colName\';' }" FIELDS="">

The index does exist, but I get no response. Is SHOW supported?

[wmgilligan]

A side to this... using MvREVEALSTRUCTURE generates results AND an error: "MvREVEALSTRUCTURE: MvREVEALSTRUCTURE is an Unsupported Operation "

[wmgilligan]

Update - got this to work. For future to anyone....

<MvOPENVIEW NAME = "data" VIEW = "keycheck" QUERY = "show index from mytable where Column_name='myColName'">
<MvIF EXPR = "{ NOT keycheck.d.EOF }">
    <MvREVEALSTRUCTURE NAME = "data" VIEW = "keycheck" VARIABLE = "l.columns">
    <MvASSIGN NAME="g.columns" VALUE="{ l.columns }">
    <MvWHILE EXPR = "{ NOT keycheck.d.EOF }">
       <MvEVAL EXPR="{ miva_variable_value( 'keycheck.d.' $ l.columns[ 1 ]:field_name ) $ ' <br>' }">
        <MvSKIP NAME = "data" VIEW = "keycheck" ROWS = 1>
    </MvWHILE>
</MvIF>

<MvCLOSEVIEW Name="data" VIEW ="keycheck">

This is a great resource: http://www.mivascript.com/item/mivas...STRUCTURE.html