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 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]> Sent: Wednesday, November 05, 2003 7:02 PM Subject: how see list of a table's indexes? > Hi Group, > > Please forgive me if this has an obvious answer, but I couldn't find it > in the MySQL v4.1 manual --- how can I see what indexes (and which > columns are indexed) for a table? > > > > Thanks! > > Holly -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]