SHOW INDEX
Go Up to isql Command Reference
Displays index information for a specified index, for a specified table, or for all tables in the current database.
SHOW {INDICES | INDEX {index | table} };
Argument | Description |
---|---|
<index> |
Name of an existing index in the current database |
<table> |
Name of an existing table in the current database |
Description: SHOW INDEX
displays the index name, the index type (for example, UNIQUE
or DESC
), and the columns on which an index is defined.
If the index argument is specified, SHOW INDEX
displays information only for that index. If table is specified, SHOW INDEX
displays information for all indexes in the named table; to display existing tables, use SHOW TABLES
. If no argument is specified, SHOW INDEX
displays information for all indexes in the current database.
SHOW INDEX
has a shorthand equivalent, SHOW IND
. SHOW INDICES
is also a synonym for SHOW INDEX
. SHOW INDEXES
is not supported.
Examples: To display indexes for database employee.ib
, enter:
SHOW INDEX;
RDB$PRIMARY1 UNIQUE INDEX ON COUNTRY(COUNTRY)
CUSTNAMEX INDEX ON CUSTOMER(CUSTOMER)
CUSTREGION INDEX ON CUSTOMER(COUNTRY, CITY)
RDB$FOREIGN23 INDEX ON CUSTOMER(COUNTRY)
. . .
To display index information for the SALES
table, enter:
SHOW IND SALES;
NEEDX INDEX ON SALES(DATE_NEEDED)
QTYX DESCENDING INDEX ON SALES(ITEM_TYPE, QTY_ORDERED)
RDB$FOREIGN25 INDEX ON SALES(CUST_NO)
RDB$FOREIGN26 INDEX ON SALES(SALES_REP)
RDB$PRIMARY24 UNIQUE INDEX ON SALES(PO_NUMBER)
SALESTATX INDEX ON SALES(ORDER_STATUS, PAID)