SQLite Cloud

LIST INDEXES

Syntax

LIST INDEXES

Privileges

READWRITE

Description

The LIST INDEXES command returns a list of all indexes defined inside the currently used database.

Return

A Rowset with the following columns:

  • name: index name
  • tbl_name: table name

Example

> LIST INDEXES
--------------------------|---------------|
 name                     | tbl_name      |
--------------------------|---------------|
 IFK_AlbumArtistId        | Album         |
 IFK_CustomerSupportRepId | Customer      |
 IFK_EmployeeReportsTo    | Employee      |
 IFK_InvoiceCustomerId    | Invoice       |
 IFK_InvoiceLineInvoiceId | InvoiceLine   |
 IFK_InvoiceLineTrackId   | InvoiceLine   |
 IFK_PlaylistTrackTrackId | PlaylistTrack |
 IFK_TrackAlbumId         | Track         |
 IFK_TrackGenreId         | Track         |
 IFK_TrackMediaTypeId     | Track         |
--------------------------|---------------|