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]