SHOW KEYS FROM table;
-----Original Message-----
From: Bill Long [mailto:[EMAIL PROTECTED]]
Sent: Thursday, 18 January 2001 12:24
To: [EMAIL PROTECTED]
Subject: How to get a list of indexes on a table
*This message was transferred with a trial version of CommuniGate(tm) Pro*
is there an easy way besides doing a mysqldump to show all the indexes
on a table and their details?(name, table, column(s), type, etc).
I can't seem to find a way to do it. If one doesn't exist, does somebody
have a program that will parse the index files and show that info? or do
I need to write one?
bill
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail
<[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
The information contained in this email is privileged and confidential
and intended for the addressee only. If you are not the intended
recipient, you are asked to respect that confidentiality and not
disclose, copy or make use of its contents. If received in error
you are asked to destroy this email and contact the sender immediately.
Your assistance is appreciated.
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
