Click here to view and discuss this page in DocCommentXchange. In the future, you will be sent there automatically.

SQL Anywhere 10.0.1 » SQL Anywhere Server - SQL Usage » Working with Database Objects » Working with indexes

Dropping indexes Next Page

Index information in the catalog

The ISYSIDX system table provides a list of all indexes in the database, including primary and foreign key indexes. Additional information about the indexes is found in the ISYSPHYSIDX, ISYSIDXCOL, and ISYSFKEY system views. You can use Sybase Central or Interactive SQL to browse the views for these tables in order to see the data they contain.

Following is a brief overview of how index information is stored in the system tables: