Home » MCQs » MariaDB MCQs

Which MariaDB statement is used to display the list of all indexes?

40. Which MariaDB statement is used to display the list of all indexes?

1. SHOW INDEX
2. DISPLAY INDEX
3. SELECT * INDEX
4. DESC INDEX

Answer: A) SHOW INDEX

Explanation:

To get the list of all existing indexes associated with a table, we use the SHOW INDEX command.

Syntax:

SHOW INDEX FROM table_name\G