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?
- SHOW INDEX
- DISPLAY INDEX
- SELECT * INDEX
- 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