http://www.mysql.com/doc/S/H/SHOW.html
always check the docs
show index from <table>
----- Original Message -----
From: "Bill Long" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Wednesday, January 17, 2001 3:23 PM
Subject: How to get a list of indexes on a table
> *This message was transferred with a trial version of CommuniGate(tm) Pro*
> is there an easy way besides doing a mysqldump to show all the indexes
> on a table and their details?(name, table, column(s), type, etc).
>
> I can't seem to find a way to do it. If one doesn't exist, does somebody
> have a program that will parse the index files and show that info? or do
> I need to write one?
>
> bill
>
> ---------------------------------------------------------------------
> Before posting, please check:
> http://www.mysql.com/manual.php (the manual)
> http://lists.mysql.com/ (the list archive)
>
> To request this thread, e-mail <[EMAIL PROTECTED]>
> To unsubscribe, e-mail <[EMAIL PROTECTED]>
> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
>
>
>
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
