thank you, i was actually trying to access the table through C-API
and had trouble with show index when I used the following query.
"show index from db.table"
i will have to try
"show index from table from db"
thank you,
Chris
-----Original Message-----
From: Philip Mak [mailto:[EMAIL PROTECTED]]
Sent: Friday, August 17, 2001 10:16 AM
To: Christopher Teli
Cc: Mysql (E-mail)
Subject: Re: check if an index exists?
On Fri, 17 Aug 2001, Christopher Teli wrote:
> How can I check if an index exists on a table???
> Is there some where I can query the admin tables?
SHOW INDEX FROM <tablename>
---------------------------------------------------------------------
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