First get all the table names in your db:
mysql_query("show tables from [your_db_name]");
Then crawl thru the table list and get index information for each of them:
mysql_query("show index from [your_table_name]");
HTH Stas
----- Original Message -----
From: <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Wednesday, October 16, 2002 1:45 PM
Subject: [PHP] Show indexes
> Is there a way in PHP to list all of the indexes in an SQL database? Or is
> it only through SQL that this can be done? (Or can it?)
>
> --
> PHP General Mailing List (http://www.php.net/)
> To unsubscribe, visit: http://www.php.net/unsub.php
>
>
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
