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 column | Value |
|---|---|
| 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.
