From: Michael Widenius Date: April 14 1999 12:30am Subject: Way to read indexes? List-Archive: http://lists.mysql.com/perl/28 Message-Id: <14099.57683.375621.670705@monty.pp.sci.fi> MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit >>>>> "Joe" == Joe Junkin writes: Joe> Hi all. Joe> I am desperately looking for a way to read the mysql indexes from DBI. I can see Joe> that msql has a function for ListIndex, but it is not for MySQL. Is ListIndex on Joe> the module agenda? If not, how can I get this information from within Perl? Joe> I have an administrative interface into mysql and need to be able to read/edit Joe> all of the indexes for a table. Hi! In MySQL you can do almost anything with SQL commands (as opposite to mSQL where you have different interfaces) Try: SHOW INDEX from table_name Regards, Monty