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
run List_Index_Detailed "CUSTOMERS"
produces:
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
If tablename is omitted, a row is produced for each indexed column.