---
title: "How can you see all indexes defined for a table?"  
description: "How can you see all indexes defined for a table?"  
author: "Anonymous User"  
published: 2011-11-04  
updated: 2020-09-15  
canonical: https://www.mindstick.com/interview/1325/how-can-you-see-all-indexes-defined-for-a-table  
category: "mysql"  
tags: ["mysql"]  
reading_time: 1 minute  

---

# How can you see all indexes defined for a table?

SHOW INDEX FROM techpreparation_questions; \
\
where 'techpreparation_questions' is a table name.

## Answers

### Answer by Anonymous User

SHOW INDEX FROM techpreparation_questions; \
\
where 'techpreparation_questions' is a table name.


---

Original Source: https://www.mindstick.com/interview/1325/how-can-you-see-all-indexes-defined-for-a-table

Copyright © MindStick Software Pvt. Ltd. This Markdown version is provided for developers, AI systems, and offline reading.