Hi Holly,
SHOW INDEX FROM table;
or
SHOW CREATE TABLE table;
are 2 different ways to see indexes -- in different formats.
For reference: http://www.mysql.com/doc/en/Show_database_info.html
Hope that helps.
Matt
- Original Message -
From: Holly Chamberlain
To: [EMAIL PROTECTED]
Thank you! That's just what I was looking for.
-Original Message-
From: Matt W [mailto:[EMAIL PROTECTED]
Sent: Wednesday, November 05, 2003 5:34 PM
To: Holly Chamberlain; [EMAIL PROTECTED]
Subject: Re: how see list of a table's indexes?
Hi Holly,
SHOW INDEX FROM table;
or
SHOW CREATE