Re: check if an index exists?

2001-08-17 Thread Philip Mak
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

Re: check if an index exists?

2001-08-17 Thread Peter van Dijk
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

RE: check if an index exists?

2001-08-17 Thread Christopher Teli
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

RE: check if an index exists?

2001-08-17 Thread Johnson, Gregert
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

Re: check if an index exists?

2001-08-17 Thread Stefan Hinz
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