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
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
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
To: Mysql (E-mail)
Subject:check if an index exists?
How can I check if an index exists on a table???
Is there some where I can query the admin tables?
Chris
Dear Chris,
How can I check if an index exists on a table???
The manual sais: SHOW INDEX FROM tbl_name [FROM db_name]
Check: http://www.mysql.com/doc/S/H/SHOW.html
Regards,
--
Stefan Hinz
Geschäftsführer / CEO iConnect e-commerce solutions GmbH
# www.js-webShop.com www.iConnect.de