====== List_Index_Detailed routine    ======


 
==== Description ====
 
Returns detailed information about indexes for a specified table or for all tables.
 
==== Syntax ====
 
**List_Index_Detailed**(//tablename//)
 
==== Parameters ====
 
The List_Index routine has the following parameter.

^Parameter^Description^
|//Tablename//|Specifies the table name to find index information for. If null, then indexing information is returned for all attached tables.||

 
==== Returns ====
 
A row for each column specified in //returncolumnlist//. Each return row contains the following:

(table, column, indexes)

Return columnValue                                                                               
//Table//    Table name.                                                                         
//Column//   Column name.                                                                        
//Indexes//  "Xref" for cross reference, "Btree" for BTree, "Relational" for relatoinal.//.
 //
 
==== Example ====
 
<code>
run List_Index_Detailed "CUSTOMERS"
</code>

produces:

<code>
Table Name      , Column Name                   , Index Information

----------------, ------------------------------, -------------------

CUSTOMERS       , CUSTOMER_NAME                 , Xref

CUSTOMERS       , CUSTOMER_NAME_XREF            , Btree

CUSTOMERS       , FNAME                         , Btree

CUSTOMERS       , LNAME                         , Btree

CUSTOMERS       , STATE                         , Btree Xref

CUSTOMERS       , STATE_XREF                    , Btree
</code>

If tablename is omitted, a row is produced for each indexed column.