On Fri, Aug 17, 2001 at 09:32:05AM -0700, Christopher Teli wrote:
>
> How can I check if an index exists on a table???
> Is there some where I can query the admin tables?
'DESCRIBE tablename' or 'SHOW COLUMNS FROM tablename'. Figure out
where it says 'index' for yourself :) (since I don't know exactly :)
Greetz, Peter
--
Against Free Sex! http://www.dataloss.nl/Megahard_en.html
---------------------------------------------------------------------
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