What does the SQL statement SHOW INDEX FROM table_name; do?

A. Shows the structure of an index

B. Displays a list of all indexes in a database

C. Shows the indexes associated with a specific table

D. Deletes an index from a table

Correct Answer is :

C. Shows the indexes associated with a specific table