Dropping Index
 

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

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

Change ADD to DROP, IIRC.

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

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

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

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 :)

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