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:
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
show index from tablename;
This returns a result set listing all indexes on the table.
--Greg Johnson
-Original Message-
From: Christopher Teli [mailto:[EMAIL PROTECTED]]
Sent: Friday, August 17, 2001 12:32 PM
To:
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