How To Get a List of Indexes of an Existing Table?

To see the index for a specific table use SHOW INDEX command.

SHOW INDEX FROM yourtable;