Re: Show indexes
| From: | Stas Maximov | Date: | Wed, 16 Oct 2002 13:39:13 +0000 |
| Subject: | Re: Show indexes | ||
| References: | 1 | Groups: | php.general |
| Request: | Send a blank email to php-general+get-120189@lists.php.net to get a copy of this message | ||
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: <Liam.Gibbs@dfait-maeci.gc.ca>
To: <php-general@lists.php.net>
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
>
>