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
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
*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