Contents Index Implementing the recommendations Working with temporary tables

ASA SQL User's Guide
  Working with Database Objects
    Working with indexes

Indexes in the system tables


All the information about indexes in a database is held in the system tables SYS.SYSINDEX and SYS.SYSIXCOL. The information is presented in a more readable format in the system view SYS.SYSINDEXES. You can use Sybase Central or Interactive SQL to browse the information in these tables.


Contents Index Implementing the recommendations Working with temporary tables