RE: How to get a list of indexes on a table

2001-01-17 Thread Quentin Bennett
SHOW KEYS FROM table; -Original Message- From: Bill Long [mailto:[EMAIL PROTECTED]] Sent: Thursday, 18 January 2001 12:24 To: [EMAIL PROTECTED] 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

Re: How to get a list of indexes on a table

2001-01-17 Thread Eric Fitzgerald
http://www.mysql.com/doc/S/H/SHOW.html always check the docs show index from - 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 > *Thi

How to get a list of indexes on a table

2001-01-17 Thread Bill Long
*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 progr