How to show indexes 1

[jsgoober]

I am new with MySQL and would like to know a way
to show/display all of my indexes within a database.

Or at least to show whether a table has indexes or not.

Thanks for the help.

Jay

 

[sleipnir214]

One way is to issue the query:

show index from tablename


For more information:

http://www.mysql.com/doc/en/SHOW.html

Want the best answers? Ask the best questions:

http://www.catb.org/~esr/faqs/smart-questions.html

TANSTAAFL!

 

[jsgoober]

Thank you Sleipnir214 +