index listing question

[bastienk]

We have multiple DBs and need to replicate the index structure across the various instances.

Is there a quick way to generate a list of all the indexes on a DB?

For info: we have both MySQL CC and PhpMyAdmin as guis to the DB...

TAI


Bastien

Cat, the other other white meat

 

[TonyGroves]

You could use:
[tt]
SHOW INDEX FROM tbl1;
SHOW INDEX FROM tbl2;
SHOW INDEX FROM tbl3;
[/tt]
That's the quickest I can think of.

-----
ALTER world DROP injustice, ADD peace;