Dropping Index

[Boofo]

Can someone tell me how you would drop an index? I want to reverse this query:

ALTER TABLE `attachment` ADD INDEX ( `postid` );

[filburt1]

Change ADD to DROP, IIRC.

[Boofo]

I did that before I wrote the above request and I got an error.

[Xenon]

why not just use phpmyadmin ?
it's much easier to just click on the drop index link ;)

[Boofo]

I was in phpmyadmin and I didn't see any drop index link. Where is it, sir? ;)

[Xenon]

it's right to the index when you view tha table properties.
maybe it's named delete or something like, i just have the german version here :)

[Boofo]

I found it right after I posted that message. Sorry about that. ;) Thank you for letting me know that was there.