Removing Indexes - Free website templates

		Free website templates > Web Template Help > PHP and MySQL
Removing Indexes

Join now to share free website templates or post on the forum. If you have never been on a forum before read the FAQ. It's quick, easy and free to join!

LinkBack

Thread Tools

Display Modes

#1 (permalink)

06-29-2009, 10:13 AM

gilbertsavier gilbertsavier is offline

Junior Member

Join Date: Jun 2009

Posts: 25

gilbertsavier is on a distinguished road

Removing Indexes

Hi,
Beside creating index you can also removing index by using DROP INDEX statement in MySQL. Interestingly, DROP INDEX statement is also mapped to ALTER TABLE statement. Here is the syntax:

DROP INDEX index_name ON table_name

« Previous Thread | Next Thread »

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Posting Rules
You may not post new threads You may not post replies You may not post attachments You may not edit your posts BB code is On Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On Forum Rules

All times are GMT. The time now is 01:42 AM.